Previous Topic Next Topic

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

Answer 1 / 1
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
0
Tutu
Jul 8, 2010 at 10:42 AM
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!
0
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
0
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
0