Combine 3 columns into 1 column (not 1 cell)

[Closed]
Report
-
Posts
1
Registration date
Monday November 15, 2010
Status
Member
Last seen
November 15, 2010
-
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?

1 reply


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!
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
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
Posts
1
Registration date
Monday November 15, 2010
Status
Member
Last seen
November 15, 2010

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