Unpivot Data - Merge tables. The tables have different headings|Power Query|Excel Forum|My Online Training Hub

Hello

Looking for a bit of PQ help.

I use the unpivot function regularly and have merged multiple tables but they always have the same columns names.  i.e Jan | Feb | Mar etc now I have multiple table to unpivot and merge but the columns names are not the same.

So, one table1 could have 3 columns, table2 5 columns and all column names differ, so, my Pivot function to cleanse my data currently doesn't work as is based off the column header names of table1 so then I apply the function to table 2 it errors out

Is there a way to create Pivot Function to simply take any columns in the tables and unpivot?

Hope that makes sense

Thanks for any help

B