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
Screen Shot 2
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
Screen Shot 2