Create One List from multiple columns/sheets

tclass117 · #1 08-23-2016, 01:53 PM

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!

tclass117 · #2 08-23-2016, 02:06 PM

https://support.office.com/en-us/art...e-e55b20cda2ef ? ?

tclass117 · #3 08-23-2016, 03:22 PM

I'm stumped.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Create multiple slides from list of slide titles	Roscoe2016	PowerPoint	3	02-02-2016 06:11 PM
Mail merge from excel - need to create sheets and create a table	bluenosebex	Mail Merge	5	08-02-2015 05:34 PM
copy second row from multiple sheets	Brian Reilly	Excel Programming	1	03-30-2015 01:21 PM
How to create multiple dissimilar columns in Word?	cmnielsen	Word Tables	4	01-31-2015 01:45 AM
form a database from multiple sheets	udea	Excel	1	04-25-2011 02:34 AM