Import multiple excel sheets as separate columns

[choksijugal]

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.

[joshuaburkhow · Accepted solution]

Hi @choksijugal 

This is how I would do it

[choksijugal]

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

[joshuaburkhow]

Sorry @choksijugal I am not following. Are you able to post an example?