Splitting Mixed Data into New Columns

[tj3678]

Hi all,

I am trying to take mixed data (numbers and states) and split them into two columns while assigning a state to each number. For example, Illinois below has 3 numbers above it in the input sample and I would like to move Illinois next to each number where it is applicable.  Final output should look like sample attached below:

                        

Any help is appreciated!

[benakesh]

Hi @tj3678 ,

This works with sample data .

Sort ( to get states on top )  , Multi row  ( adding states to zip)   , filter and sort  ( to get original order) .

[JosephSerpis · Accepted solution]

Hi @tj3678 I mocked up an example let me know what you think?

[tj3678]

Thanks! @JosephSerpis