Assimilating text data from multiple workbooks

[RhinoBane]

I created a work sheet with 15 questions. I presented the questionnaire to 20 people. I now want to create a worksheet with the correlated information in progressive order. 

Question 1:

Response 1 

Response 2

etc...

Question 2

Response 1

etc..etc..

Help

[v-stephen-msft · Accepted solution]

Hi @RhinoBane ,

You can put these excel files into the same folder, and go to Power BI Desktop, click Get Data-> Folder. You can directly combine them. Please refer to

Combine files (binaries) in Power BI Desktop - Power BI | Microsoft Learn

Or try to shape and combine data in Power Query after data is imported. Please refer to

Tutorial: Shape and combine data in Power BI Desktop - Power BI | Microsoft Learn

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly