Combine multiple columns into one while ignoring Null cells

JingYih_Herbalife

Hi,

How do I combine the data below into the desired output?

Thanks in advance, JY

arnel_de_guzman12

You need to Transpose and Summarize( Group by ID and Concatenate the address).

Transpose

Summarize

Combine-multiple-columns-into-one-while-ignoring-Null.yxmd