Create One List from multiple columns/sheets
Hello All! Tyler here! New! Hi!
I'm looking to Create One List from multiple columns/sheets on Sheet 1 without spaces between columns or sheets. They don't have to be in order for now, just all collected into one nice list.
Example
Sheet 2:
Column 1:
1
13
Column 2: (Empty)
Column 3:
3
5
Sheet 3:
Column 1:
1
1
1
I'm looking for a formula that would show Sheet 1's First Column to be:
1
13
3
5
1
1
1
Is this possible? Without empty spaces in between?
Any references?
Thanks!
|