This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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: