Excel - Pivot Table - Data from multiple sheets

Question

I'm trying to create an Excel Pivot table from multiple sheets onto 1 pivot table. The problem I'm having is that I have the data I'm pulling from separated out by week and it isn't formatted as a table. I am including a screenshot of where the source data comes from. Is there any way to get a pivot table to work from this? What I am wanting to do is pull from the LOB column and have a count of the ones listed under there. Any help is appreciated.

enter image description here

horseyride · Accepted Answer · 2021-03-02 15:47:10Z

0

I'd just load the three different sheets into PowerQuery (data .. .from table/range .... file ... [x] table has headers .... file ... close and load to ... only create connections) then append the queries (data ... get data ... combine queries ... append ) and load it back to excel as a pivot table (file .. close and load as ... pivot table report)

answered Mar 2, 2021 at 15:47

horseyride

21.8k3 gold badges15 silver badges26 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

merlin1320 Over a year ago

Thank you for your response. That did help. The problem is now it is showing the header for LoB that I have listed in there. Should I do the range over and over to select each "week" in the table I have set up?

horseyride Over a year ago

I assume you created the ranges [x] with headers ? Pos the code generated viewed with home. Advanced

Collectives™ on Stack Overflow

Excel - Pivot Table - Data from multiple sheets

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related