Hi,
I have multiple sheet of data and i want to make a summary sheet that combines all the data into one column. Each sheet has a column labeled Distance with data listed below, but from sheet to sheet the number of rows of data isnt consistent. Is there a way to create a summary column in another sheet that creates a column of all the data, from sheet 1 to sheet 10 in consecutive rows?
for example, sheet one would have
distance
.03
.04
.09
.01
then, sheet 2 would have
distance
.09
.08
.03
.08
.01
.05
etc. i want to make one column that lists the values in sheet one, then the values in sheet 2, then sheet 3, etc. si there is a column called
distance
03
.04
.09
.01
.09
.08
.03
.08
.01
.05
does that make sense?
any suggestions?
thanks!
Bookmarks