This is a test version of Biostars. For the public version, visit https://www.biostars.org.
How to arrange the second column according to the first column?

I have two lists in Excel: List 1:

aa
33
2a
3de
432
s2e
3rr

List 2:

33
3de
432
s2e
2a
3rr
aa

(These are just an example. Actually, my list contains over 200 values per a column.) I want to arrange List 2 according to the List 1. In other words, I want List 2 to be exactly sorted as List 1 in Excel.

Can someone help me please? I have tried to use vlookup in Excel to arrange the two columns but it did not work.

excel
• 1,088 views • link
updated by Pierre Lindenbaum Pierre Lindenbaum • written by Grunir112 • Grunir112

Are these columns in separate files/separate tabs in same file/spreadsheets?

• 0 views • link
written by GenoMax GenoMax

They are in the same tab in same file.

• 0 views • link
written by Grunir112 • Grunir112

Hello Grunir112!

We believe that this post does not fit the main topic of this site.

I do not see the connection to bioinformatics here. I am not sure we should do general excel support.

For this reason we have closed your question. This allows us to keep the site focused on the topics that the community can help with.

If you disagree please tell us why in a reply below, we'll be happy to talk about it.

Cheers!

• 0 views • link
written by Michael Dondrup Michael Dondrup

What are the odds, Michael?!

• 0 views • link
written by Ram Ram

Hello Grunir112!

We believe that this post does not fit the main topic of this site.

This is not a bioinformatics question. Please check stackoverflow.

For this reason we have closed your question. This allows us to keep the site focused on the topics that the community can help with.

If you disagree please tell us why in a reply below, we'll be happy to talk about it.

Cheers!

• 0 views • link
written by Ram Ram

0 answers

No answers yet.

Log in to answer this question.

More posts like this