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 KeyValue1A2B3C4D Sheet: November KeyValue1E2F3G4H Goal: KeyOctoberNovember1AE2BF3CG4DH I am looking for some scalable method because my workbook has 50-60 sheets.

Import multiple excel sheets as separate columns

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.

Input

Accepted answers

joshuaburkhow

Hi @choksijugal

This is how I would do it

Read Sheets.yxzp

All comments

joshuaburkhow

Hi @choksijugal

This is how I would do it

Read Sheets.yxzp

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

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703