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
Solved! Go to 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
Worked like a charm!
Thanks,
-Jon