K
Keith
Can anyone give me some advice on a neater way to organize my spreadsheet
data?
Here is the scenario.
I print out several different data reports. Each report contains 2 to 7
columns. The reports are printed on a monthly basis and give statistical
information. I would like to show the trends over a period of time by month.
For example, I have one report called "Enhanced System" and within that
report are 2 columns columns called Queue Length and Processes. Then I have
another report called "Performance" and that report has 3 columns called
Memory, Disk, and CPU.
Each report has only 2 records of data, one record for each server monitored.
I was going to create one column on the left with each row for a column from
the report then go horizontally with headers as months however the problem is
that I also need to know which report each row goes with. In the example I
only gave 2 reports but in truth there are 21 reports with number of
statistical columns varying.
Sept Oct Nov Dec
report1 column1
report1 column2
report2 column1
report2 column2
report2 column3
If any suggestions come to mind PLEASE let me know. Thanks.
data?
Here is the scenario.
I print out several different data reports. Each report contains 2 to 7
columns. The reports are printed on a monthly basis and give statistical
information. I would like to show the trends over a period of time by month.
For example, I have one report called "Enhanced System" and within that
report are 2 columns columns called Queue Length and Processes. Then I have
another report called "Performance" and that report has 3 columns called
Memory, Disk, and CPU.
Each report has only 2 records of data, one record for each server monitored.
I was going to create one column on the left with each row for a column from
the report then go horizontally with headers as months however the problem is
that I also need to know which report each row goes with. In the example I
only gave 2 reports but in truth there are 21 reports with number of
statistical columns varying.
Sept Oct Nov Dec
report1 column1
report1 column2
report2 column1
report2 column2
report2 column3
If any suggestions come to mind PLEASE let me know. Thanks.