Hello excel gurus,
I have and excel file with :
Sheet 1:
Sheet 2:
I have some 20+ sheets like "Sheet 1" and "Sheet 2".
I would like to have a new sheet (or maybe in another excel file) which will gather (pull) all the data from the different column A of all these sheets i.e result :
New Sheet :
P.S The number of rows are different in each existing sheet.
I have and excel file with :
Sheet 1:
Col A | |
data1 | |
data2 | |
<<Empty cell>> |
Sheet 2:
Col A | ||
data a | ||
data b | ||
data c | ||
<<Empty cell>> |
I have some 20+ sheets like "Sheet 1" and "Sheet 2".
I would like to have a new sheet (or maybe in another excel file) which will gather (pull) all the data from the different column A of all these sheets i.e result :
New Sheet :
Col A | |
data1 | |
data2 | |
data a | |
data b | |
data c |
P.S The number of rows are different in each existing sheet.