Collect data from different columns to the other columns

Question

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,

phone.xlsx

Data and table for result.xlsx

mceleavey · Accepted Answer

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 Answer

Hi @Simon1187,

I have prepared a workflow for you:

The output:

Emil_Kos · Accepted Answer

I was so slow but this one was super fun 😄

I will use this as our internal monthly challenge 😛