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 in the following manner.

|__A______|__B__|__C__|__D__|__E__|__F__|
1|File1_name| 500 | 751 | 362 | 458 | 258 |
2|File2_name| 234 | 254 | 458 | 447 | 457 |
3|File3_name| 215 | 151 | 144 | 124 | 458 |
4|File4_name| 124 | 598 | 125 | 587 | 125 |
5|File5_name| 111 | 254 | 875 | 548 | 154 |

File1_name.png