Excel Cross Tab Formatting

[Orion9542]

Hi All,

I've inherited an Excel workbook in the following format:

 

I would like to transform my data so it looks as follows:

 

 Any ideas?

Thanks

[BenMoss · Accepted solution]

Step 1. Transpose your data. Your date fields should act as your 'data fields' and your other fields should be your key fields.

Step 2. Cross-tab your data. Your date field should by your group by field. Your header field will be the name of your column A, then the value field will be the field 'value' generated from your transpose.

Give this a try and get back to us if you need further support :)

Ben

[Orion9542]

Worked like a charm!  

Thanks,

-Jon