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!
Solved! Go to Solution.
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) .
Hi @tj3678 I mocked up an example let me know what you think?
Thanks! @JosephSerpis