Hi,
Attached is a very small Excel that is an output from a program that I use. I want to transform the information into a format that I can then input into another Excel without having to perform multiple "Copy & Paste" operations.
The 1409 sheet is the original data. Sheet 1 is how my pivot table presents it whilst Sheet 2 is how I want it to look. I even added a numerical element to the subject to try and achieve the correct look but Pivot seems to ignore this.
I'm hoping that as the data is not complex (only 8 columns) then someone can advise what I should be doing.
Thanks in advance,
Cheers
Paul
Bookmarks