Forum Discussion
Rename Columns in Sample File Dinamically
Dear Colleagues,
I need to append together several excel files on a quarterly basis. The Date is structured the same way (4 columns, first the product, then one column for each month of the quarter, example: january, february, march, and then a total). The Problem I have, and why I can't just combine the files, is that the product column is named in some other way for each file.
I have extensively searched for a solution, but can't seem to find it on my own.
The files look like this:
File A Example:
| Product Type | January | February | March | Total |
| Abonnement | 5 | 5 | 5 | 15 |
| Blog | 12 | 18 | 5 | 35 |
| Video | 1 | 5 | 6 | 12 |
File B Example:
| Row Type | January | February | March | Total |
| Product A | 20 | 30 | 40 | 90 |
| Product B | 5 | 10 | 20 | 35 |
| Product C | 5 | 7 | 8 | 20 |
Expected Result:
| Item | January | February | March | Total |
| Abonnement | 5 | 5 | 5 | 15 |
| Blog | 12 | 18 | 5 | 35 |
| Video | 1 | 5 | 6 | 12 |
| Product A | 20 | 30 | 40 | 90 |
| Product B | 5 | 10 | 20 | 35 |
| Product C | 5 | 7 | 8 | 20 |
Thanks in Advance for the help!
4 Replies
Hello AlienSx,
I use as source a Sharepoint Folder, where I upload all the files each quarter. Wenn I pull this Folder into Power Query and combine, I get an error (presumably because of the Sheet name, as it is auto generated by the software from where the data comes from). So instead of directly combining the content of all Excel Files (which I can't because of the sheet names), how could I combine the files, independently of sheet name?
