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
解決済! 解決策の投稿を見る。
If you use the Crosstab tool and don't group on anything, it should yield the desired output.