Forum Discussion
Solved
Pivot Table
Hello, I have tried to watch videos and have had no luck on turning this data in to a pivot table I need. I have attached the workbook and an example of what we have already for a different set o...
After clicking anywhere in the pivot table, I activated the Design tab of the ribbon.
In the Layout group, I selected Show in Tabular Form from the Report Layout drop-down.
Sometimes Excel groups dates in a pivot table automatically.
Right-click any of the dates in the pivot table, and select Ungroup... from the context menu.
How did you get the dates to be in their own column?
After clicking anywhere in the pivot table, I activated the Design tab of the ribbon.
In the Layout group, I selected Show in Tabular Form from the Report Layout drop-down.
HansVogelaar I was hoping you could help me one more time. I am wanting to know how many points an OP# did on any given day. I have a master sheet set up that can view 1 at time when I put in their OP#.
=VLOOKUP($T$4&S5,CHOOSE({1,2},$B$2:$B$401360&$C$2:$C$401360,$D$2:$D$401360),2,0)An alternative could be this formula.
- Perfect. Thank you so much for your help.
