I am trying to take over 300,000 rows of information under two columns and pivot that information into two rows — header and data underneath those headers. One of the columns has repetitive headers alongside another which has the information that’s supposed to be under each header.
I have been looking for examples and have not worked with pivot features on Excel. Any assistance on this is greatly appreciated. I’m currently going line by line and doing the cut and paste method.
The provided image is simply an example of what I’m trying to accomplish.
I have been looking for examples and have not worked with pivot features on Excel. Any assistance on this is greatly appreciated. I’m currently going line by line and doing the cut and paste method.
The provided image is simply an example of what I’m trying to accomplish.