Here is the data I have:
column 1 column 2 column 3
smith blue 4
smith green 3
smith red 4
jones blue 2
jones red 2
jones green 3
jones yellow 2
brown red 3
brown blue 3
etc.
I need it to be like this:
Column 1 column 2 column 3 column 4 column 5 column 6 etc.
smith blue 4 green 3 red 4
jones blue 2 red 2 green 3
Thank you for the assistance.
column 1 column 2 column 3
smith blue 4
smith green 3
smith red 4
jones blue 2
jones red 2
jones green 3
jones yellow 2
brown red 3
brown blue 3
etc.
I need it to be like this:
Column 1 column 2 column 3 column 4 column 5 column 6 etc.
smith blue 4 green 3 red 4
jones blue 2 red 2 green 3
Thank you for the assistance.