I am a bit stuck with a pretty basic problem.
I have multiple sheets in an Excel file and want to import all, but want to add the data from each sheet as a new column. Each sheet has the same first column.
Example:
Sheet: October
Key | Value |
1 | A |
2 | B |
3 | C |
4 | D |
Sheet: November
Key | Value |
1 | E |
2 | F |
3 | G |
4 | H |
Goal:
Key | October | November |
1 | A | E |
2 | B | F |
3 | C | G |
4 | D | H |
I am looking for some scalable method because my workbook has 50-60 sheets.
Solved! Go to Solution.
Hi @choksijugal
This is how I would do it
Thanks a lot @joshuaburkhow! I realized there is a slight complication because of which it did not run on my data - the second column contains the headers. Is there a fix you can suggest I can apply for that?
To provide a better idea, the key column is the second column and the value column is the third in my data. I could delete the first column from every sheet and your solution would work but that is painfully difficult
Sorry @choksijugal I am not following. Are you able to post an example?