excel - Sort a list by another list... to organize matching pairs on the same row -


i know title sounds little funky. i'm trying do: have large list of data , i'm trying sort small list off of large list. want small list row number match large list row number. looks this:

aaa     aaa bbb     ddd ccc     eee ddd     hhh eee     kkk fff ggg hhh iii jjj kkk 

what want this:

aaa     aaa bbb     ccc     ddd     ddd     eee     eee    fff ggg hhh     hhh iii jjj kkk     kkk 

i didn't see in research, wondering if there's simple way in excel. tried pivot table couldn't results want.

insert column between with:

=iferror(if(match(a1,c:c,0)>0,a1,),"")   

copied down, select first 2 columns, copy, paste special, values... on top , delete third column.


Comments

Popular posts from this blog

java - Intellij Synchronizing output directories .. -

git - Initial Commit: "fatal: could not create leading directories of ..." -