- My Forums
- Tiger Rant
- LSU Recruiting
- SEC Rant
- Saints Talk
- Pelicans Talk
- More Sports Board
- Fantasy Sports
- Golf Board
- Soccer Board
- O-T Lounge
- Tech Board
- Home/Garden Board
- Outdoor Board
- Health/Fitness Board
- Movie/TV Board
- Book Board
- Music Board
- Political Talk
- Money Talk
- Fark Board
- Gaming Board
- Travel Board
- Food/Drink Board
- Ticket Exchange
- TD Help Board
Customize My Forums- View All Forums
- Show Left Links
- Topic Sort Options
- Trending Topics
- Recent Topics
- Active Topics
Started By
Message
re: Excel Help - Suggestions
Posted on 4/22/24 at 12:52 pm to dtett
Posted on 4/22/24 at 12:52 pm to dtett
quote:A lot of people jumped straight to "do a pivot table" which is the answer once you get the 52 (or however many) files together. Power Query is the easist way I know to do this.
I would use power query in two steps.
One to combine all the tabs into one data source.
Then query all 52 documents into one master file.
Then you can slice and dice like you would any table in excel.
Posted on 4/23/24 at 10:36 am to RoyalWe
quote:
Power Query is the easist way I know to do this.
This was the method I chose, and it worked perfectly. Never had used the tool before but once I was able to get the first sheet transformed correctly it went pretty smooth. I created a second sheet in the workbook for my formulas, created a formula array to identify unique values and then sumifs the rest of the columns. Once that workbook was completed, I just performed the same transformations on the next one, copied my formula sheet, and updated the formulas. Took about an hour and half all in.
I appreciate the assistance.
Popular
Back to top
Follow TigerDroppings for LSU Football News