Hi,
I have inherited an Excel spreadsheet and the data needs normalised.
See attached mock-up where data is provided for 3 months but the actual spreadsheet has data dating back for the past 5 years.
I would like to transpose the data into a table as I prefer to work with pivot tables for reporting purposes.
If someone could help me it would be brilliant as it would save me lots of time.
Thanks
Bookmarks