Combine 3 columns into 1 column (not 1 cell)

Closed
Tutu - Jul 7, 2010 at 02:27 PM
hpetrosyan Posts 1 Registration date Monday November 15, 2010 Status Member Last seen November 15, 2010 - Nov 15, 2010 at 12:51 PM
Hello,


I have a few columns from different worksheets I need to combine into one column, but not like merging two cells into one cell.

It looks like this:
Worksheet 1:
1. ID100
2. ID101
3. ID112

Worksheet 2:
1. ID100
2. ID103
3. ID145
4. ID155
5. ID122

Worksheet 3:
1. ID100
2. ID101
3. ID155

I want to combine these columns into one:

Worksheet 4:
1. ID100
2. ID101
3. ID112
4. ID100
5. ID103
6. ID145
7. ID155
8. ID122
9. ID100
10. ID101
11. ID155

If I can also avoid duplicated data during the combing, it would be even better. If not, I know how to do that with the Excel formula.
Can anyone help me with the combing?

Related:

1 response

Blocked Profile
Jul 8, 2010 at 09:22 AM
Hi Tutu ,

Please add more information to your question with an example for the output you want it to ;look like.

Thanks
Hi Wandful,

Worksheet 4 is the output--all the data lined up in one column from the previous 3 worksheets.

The questions is I don't know how many entries my worksheet 1,2 and 3 will have, so I can't just do a simple cell link between worksheets. I actually have many more than 3 sheets of data that I need to combine, so I can't just do a normal copy and paste. I hope there is something in Excel that can help me put all the data in one column.

Thanks!
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Jul 9, 2010 at 11:40 PM
Could you please upload a sample EXCEL file WITH sample data, macro, formula , conditional formatting etc on some shared site like https://authentification.site , http://docs.google.com, http://wikisend.com/ , http://www.editgrid.com etc and post back here the link to allow better understanding of how it is now and how you foresee. Based on the sample book, could you re-explain your problem too
hpetrosyan Posts 1 Registration date Monday November 15, 2010 Status Member Last seen November 15, 2010
Nov 15, 2010 at 12:51 PM
Hello,
Here is an example:http: //www.speedyshare.com/files/25208768/Copy_of_re-arrange_the_products.xls. Please advise how to rearrange the data from 3 columns into on. The details are in the example......Thank you