Forum Discussion
Solved
Append multiple workbooks by column position not by headers
Hi all, I have multiple excel workbooks which I want to consolidate. The problem is column headers are different and data type can also be different in multiple workbooks. However, I know the col...
You can just Demote Headers, then combine, nice and easy.
Hi Rahul_SC ,
I created a file and video regarding this topic in Excel Power Query. Let me know if it helps. However, if you are using Power BI, then, I will share another you something else.
Data type is not an issue if all the to be appended columns are the same data type (i.e. irrespective column 1 ..5 but the actual [Name], [Address], [Age]).
File:
Regards
Kerwin
Hi, in my case, heading is not same. Just the col position is same. However, thanks for this video, learnt new thing 🙂
