Reporting on data as a row

[malcolmcringe]

How do I create a pivot table report to transform data as follows?

From:

To:

Thanks!

Cam >B)

 

[malcolmcringe]

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)