

February 1, 2019

Hi,
i haveto import at once a lot of entirely separated tables in PQ. What is the best approach to do and how to do this?:
1) Import all tables (about 50) to one worksheet on Excel and place them one by one in horizontal view (or one below another) - how to do this?
2) import all tables - every table to different specific worksheet? And how to do this in Power Query in one query ?
Please help,
Jacek Antek

VIP

Trusted Members

December 7, 2016

Hello,
Do the tables have the same structure or are they each individual?
If they all have same structure you can use Power Query, where you load the files from a folder. See this article about that approach.
If they have different structure then it is easier to just copy and paste into one file.
Br,
Anders


July 16, 2010

Hi Jacek,
If it's 50 separate queries you want outputted, then you need 50 separate queries that you create one by one (after all, they all have different starting layouts that need converting), and I'd put them into their own sheet unless you can be sure they won't ever change shape/grow in future refreshes, in which case you can put them side by side in a single sheet. Either way, there are no shortcuts, sorry.
Mynda

Answers Post
1 Guest(s)
