Reporting on data as a row

malcolmcringe

New Member
Joined
Oct 24, 2006
Messages
2
How do I create a pivot table report to transform data as follows?

From:


To:

Thanks!

Cam >B)
 

Some videos you may like

Excel Facts

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.

malcolmcringe

New Member
Joined
Oct 24, 2006
Messages
2
Bump...

Does anyone have an answer for this? I'd be really interested in figuring out how to transform data like this. I've got a huge amount of data that I'd like to transform, but I can't get it to work in a pivot table.

Please help, thanks.

Cam >B)
 

Watch MrExcel Video

Forum statistics

Threads
1,114,052
Messages
5,545,734
Members
410,702
Latest member
clizama18
Top