Move all not null values to 1st row

Question

Hello!

I am searching for the most optimized way how to get all not null values in the fields to the 1st row, please see CURRENT & DESIRED OUTPUT attached. Please also find attached the file, where I included the example.

Thank you in advance!

Best regards,

Oksana

CURRENT & DESIRED OUTPUT.png

example.xlsx

cjaneczko · Accepted Answer

If you use the Crosstab tool and don't group on anything, it should yield the desired output.