Notifications
Clear all
Power Query
2
Posts
2
Users
0
Reactions
80
Views
Topic starter
Hi,
When I use the Excel.Workbook(File.Contents... function, the data comes in okay with the exception the columns are not in the same order that the original workbook has them in.
For Example:
Original columns could be Date, Revenue, Costs, Description
Power Query would be Description, Date, Revenue Cost.
Thanks,
Posted : 15/12/2016 4:03 pm
Hi Angela,
I've not experienced that before. Are you able to share a sample file and your query so I can see if I can reproduce it.
Mynda
Posted : 15/12/2016 8:12 pm