I am looking to see if I can solve this problem using Excel- if not, I can write a script that would help me do this instead but it would be a little more time consuming.
Here is my data set:
This is just a sample of my data. The column on the left is an identification ID and the column on the right are some properties tied to that ID.
I want to manipulate the data in such a way that for each unique element on the right column, I have one row and these rows would have the repeated identification numbers (from the left column). The way it would look is:
I know about the "Text to Columns" feature in Excel but what I am trying to do seems more like "Text to Rows".
Any input is appreciated!