Mar 13 2021 07:09 PM
Hello, I have multiple excel files in a folder. Each excel workbooks contain multiple sheets. I need to combine a particular column of a table from a particular sheet from all the workbooks in the folder and arrange them row wise. All the workbooks, worksheets and tables are identical. Using power query, I have managed to combine the data however, I can't arrange them row wise. I have attached a sample excel workbook image and I would like the data to be arranged as shown in the picture.
Mar 13 2021 09:11 PM
Mar 14 2021 05:21 AM
In Power Query remove Column1, on ribbon Transform -> Transpose, rename columns, load to Excel sheet.