sorting uneven rows

Copper Contributor

I have two columns of data in excel, one has more rows than the other, is there anyway to sort them so that the data that is the same in each row lines up?

1 Reply

@mlefler75 

Maybe there is another simple way to do it, attached is an excel file with an example.

 

In youtube here is the explanation of the dynamic array formula.

https://www.youtube.com/watch?v=4qZ8ud8akus