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 · Accepted solution]

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

Transpose

Summarize