Splitting Mixed Data into New Columns

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!

Workflow

Accepted answers

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

Mixed_Data_131119.yxmd

All comments

This works with sample data .

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

split_data_11_13.yxmd

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

Mixed_Data_131119.yxmd

Thanks! @JosephSerpis

Quick Links

Tags

This months top contributors

atcodedog05 19598

Qiu 15867

MarqueeCrew 13708

apathetichell 13703