How top create a multirow formula to bring in value from left if column is blank?

Question

current data:

Column 1Column 2Column 3Column 4Column 5Column 6444     444 333   444 333555  444 333555222 444 333555222111

how do i get my table to look like this? i want column 6 to have filled with data, but i want it to fill from one column to the left first, and then if that is empty, go one more to the left, and so forth until it is no longer blank.

Column 1Column 2Column 3Column 4Column 5Column 6     444     333     555     222     111

hroderick · Answer

Presuming the highlighted aa below should be aaa

Use formula tool.

Calculate column 6

Formula is :

if !isempty([column 1]) then [column 1]

elseif !isempty([column 2]) then [column 2]

elseif !isempty([column 3]) then [column 3]

elseif !isempty([column 4]) then [column 4]

elseif !isempty([column 5]) then [column 5]

else "" endif

pedrodrfaria · Answer

Hi @gc961

Please find the updated version below:

How top create a multirow formula to bring in value from left if column is blank.yxmd

gc961 · Answer

Hey @pedrodrfaria, thank you for providing that workflow, i seem to have a few issues with it, and it was my fault when explaining it. im sorry im still getting the hang of alteryx and still learning the nuances of the program.

the data in the columns is string, not integers, so when i do the cross tab i cant aggregate values by sum. also there are columns to the right with data in it, but i want the sixth column to be the one filled from things on the left. it should in fact be like this:

column 1column 2column 3column 4column 5column 6column 7aaa dd   ffaaa  cc  ffaaa  ccbbaaff

what i need:

column 1column 2column 3column 4column 5column 6column 7aaa dd  ddffaaa  cc ccffaaa  ccbbaaff