- 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 9:58 am to Piece
Posted on 4/22/24 at 9:58 am to Piece
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.
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/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.
Popular
Back to top
Follow TigerDroppings for LSU Football News