Transposing and Consolidating Data

blu817

New member
Joined
Aug 18, 2017
Messages
13
Reaction score
0
Points
0
Excel Version(s)
2013
Howdy

I have a query that's cleaning up data but I'm a point where I need help. Now this is part of the data but in screen shot 1 shows the current state of the data. What I would like to do is transpose and the Edit Type column and put the counts beneath them like in screen shot 2. The hurdle I am running into is that some columns will have data for certain days and it nothing for other days. Hopefully the screen shots help. Any help would be greatly appreciated.


Screen Shot 1
1.jpg

Screen Shot 2
2.jpg
 
A pivot table will do this quickly.
Supply the workbook with the data like in the first screenshot.
 
I totally forgot about Pivot Tables, thanks for the suggestion and I can work with that. Thanks again!
 
Back
Top