I have a sheet with 4 columns and N rows. I would like to sort the columns leaving the empty fields when corresponding value is missing in the other columns. I need your help as I don't find a way to solve.
Maybe the example will help understand my question:
Many thanks in advance
Fabrizio
Copy all letters, remove duplicates, INDEX MATCH
You can try this: