Paul has attended:
Power BI Modelling, Visualisation and Publishing course
Excel Advanced course
Excel Power Query
I have been given 12 monthly data sheets for a year. I want to load all 12 sheets through power query and make a single table which I will use in power pivot. Each sheet has a set of common data but each has some different columns so basically I would like to take the sheet with the most columns and use that as the basis to make a single table for all. How do I do this.
RE: Excel Power Query
Hi Paul,
Thank you for the forum question.
Please have a look at the the link below.
https://community.powerbi.com/t5/Desktop/How-to-union-or-append-tables-with-different-column-order/m-p/47642 #M18801
If you have SQL experience you can write a query in PowerPivot, which can do what you want.
I hope this can help you>
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
