View Single Post
 
Old 08-23-2016, 01:53 PM
tclass117 tclass117 is offline Windows 10 Office 2016
Novice
 
Join Date: Aug 2016
Posts: 4
tclass117 is on a distinguished road
Default 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!
Reply With Quote