Previous Topic Next Topic

Combine 3 columns into 1 column (not 1 cell)

Closed
Tutu - 7 Jul 2010 à 14:27
hpetrosyan Posts 1 Registration date Monday 15 November 2010 Status Member Last seen 15 November 2010 - 15 Nov 2010 à 12:51
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

Réponse 1 / 1
Blocked Profile
8 Jul 2010 à 09:22
Hi Tutu ,

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

Thanks
Tutu
8 Jul 2010 à 10:42
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 28 January 2010 Status Contributor Last seen 5 May 2022 766
9 Jul 2010 à 23:40
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 15 November 2010 Status Member Last seen 15 November 2010
15 Nov 2010 à 12:51
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

Similar discussions

how to convert ounces (oz) to milliliter
JPortillo -
vcoolio -

1 response