Display only non-null columns.

[#1]

Hello all,

I have a large excel table with many columns.

My key is a unique number and every column marked with 1 or null.

I like to display for each number only the columns that arenot null.

Any idea for a good solution how this can be done?

I will probably will find a complex way to do so, but until Iwill, I like to get some input from you,

Who this can be done efficiently

Thanks in advance,

T.

Enclosed is excel file with some data as example, it includeonly 20 columns, in the original file I have many many more.