Collect data from different columns to the other columns

[Simon1187]

Hi every one! 

I have 6 columns that are not filled and always just three cells from six value s has value . I want to bring all data from six columns to there columns.  Could you please help me how I can bring all three values from six columns to three columns. 

Please see the sample of the.  

Thanks, 

[grchavarri]

Hi @Simon1187 

Please see attached one possible solution. 

Best, 

[mceleavey · Accepted solution]

Hi @Simon1187 ,

If I understand correctly you wish to have them all smooshed to the left, so you're only showing phone 1,2 and 3 for each row?

Please see attached workflow which produces the following results:

Hope this helps.

M.

[Emil_Kos · Accepted solution]

Hi @Simon1187,

I have prepared a workflow for you:

The output:

[Emil_Kos · Accepted solution]

I was so slow but this one was super fun 😄 

I will use this as our internal monthly challenge 😛 

[Simon1187]

Thank you very much. 

[mceleavey]