Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-23-2016, 01:53 PM
tclass117 tclass117 is offline Create One List from multiple columns/sheets Windows 10 Create One List from multiple columns/sheets Office 2016
Novice
Create One List from multiple columns/sheets
 
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
  #2  
Old 08-23-2016, 02:06 PM
tclass117 tclass117 is offline Create One List from multiple columns/sheets Windows 10 Create One List from multiple columns/sheets Office 2016
Novice
Create One List from multiple columns/sheets
 
Join Date: Aug 2016
Posts: 4
tclass117 is on a distinguished road
Default

https://support.office.com/en-us/art...e-e55b20cda2ef ? ?
Reply With Quote
  #3  
Old 08-23-2016, 03:22 PM
tclass117 tclass117 is offline Create One List from multiple columns/sheets Windows 10 Create One List from multiple columns/sheets Office 2016
Novice
Create One List from multiple columns/sheets
 
Join Date: Aug 2016
Posts: 4
tclass117 is on a distinguished road
Default

I'm stumped.
Reply With Quote
Reply

Tags
columns, combined, mutiple

Thread Tools
Display Modes


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
Create One List from multiple columns/sheets 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
Create One List from multiple columns/sheets How to create multiple dissimilar columns in Word? cmnielsen Word Tables 4 01-31-2015 01:45 AM
Create One List from multiple columns/sheets form a database from multiple sheets udea Excel 1 04-25-2011 02:34 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:29 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2023, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2023 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft