Replace Null in column and collapse multiple columns into one

Question

I have a table with multiple columns. I trying to remove Nulls in each column with the header name of the prior columns. Then collapse all columns into one.

Alteryx_review table.xlsx

U014528 · Answer

Thank you for your feedback.  The outcome is not exactly what I was looking for. It did give me other options to explore.

faiqz · Answer

Hi,

I tried to solve your problem based on my understanding. I attached my workflow with this.

replace null and combine.yxmd

binu_acs · Answer

@U014528 one way of doing this by Transposing the data and filter out the Null values