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.
You can just Demote Headers, then combine, nice and easy.
This can work. Just I need to add headers at the end manually.
