Hi All,
I have data different excel sheets and I would like to put all the data into one single sheet. I dont want the data to combine and fill the rows, which came up alot in google search. But rather I would like the data (regardless whether header is the same or different) to combine into different columns.
For example:
Sheet 1 - I have data in column A and B
Sheet 2 - I have data in column A and B
After combining, Sheet 1 data is in column A,B, and sheet 2 data is in column C, D.
Is there anyway to modify this code to have the combined data to show across the columns? (this code combines the data and puts them in rows)
--------------------------------------------------------
-------------------------------------------------------
Thank you!
Bookmarks