Reworking Data 1

[DataFanatic]

I have a series of data
Colum headings are a event types
Rows are minutes by date
Example:
t1 | t2 | t3 | t4 | t5 |
1/1/04 | 10 | 10 | | 5 | |
1/2/04 | | 5 | | 10 | 15 |
1/3/04 | 15 | 10 | 17 | | | etc

What I need is for a row to be created like

t1 | 1/1/04 | 10
t2 | 1/1/04 | 10
t4 | 1/1/04 | 5
t2 | 1/2/04 | 5
t4 | 1/2/04 | 10
t5 | 1/2/04 | 15
t1 | 1/3/04 | 15
t2 | 1/3/04 | 10
t3 | 1/3/04 | 17

I don't have any idea if thsi can be done. If anyone has any thoughts I would appreciate them.

Thanks in advance.

 

[SkipVought]

DataFanatic,

This can be accomplished using the PivotTable Wizard.

With any cell in your table selected, start the PivotTable Wizard.

Step 1 - Select the Multiple consolidation ranges option button -- NEXT

Step 2a - Select I will create the page fields option button -- NEXT



Skip,

http://www.TheOfficeExperts.com

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[SkipVought]

...continued

Step 2b - with Range textbox selected, select the data range on your sheet. ADD -- NEXT

Step 3 - Drag the Row & Column buttons off the Layout -- NEXT -- FINISH

You willl see a -cell PivotTable -- doubleclick the lower right cell.

This drills down to the data -- in the format you requested. Just change the Column Heading to suite your needs.

VOLA!



Skip,

http://www.TheOfficeExperts.com

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[DataFanatic]

WOW!!!!

I thinks this must deserve a star. Even though I wasted and hour or two struggling, this solution will save lots of time. I can't believe how powerful that pivot table is.

Thanks again.

 

[SkipVought]

Fantastic!

PivotTables are a VERY powerful tool! ;-)

Skip,

http://www.TheOfficeExperts.com

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884