Hi, I have a dataset that is duplicating data from two rows if there is more than one variable in the final column like below: ID fruit quality 1 banana yellow 2 apple green 2 apple round What I Want is for each row to be unique like below, such that if the quality column has multiple entries, it will create a new column and insert it there - column_2, column_3, column_4 and so on. ID fruit quality_1 Quality_2 1 banana yellow 2 apple green round I have looked around the forum and some text books looking for an answer to this and haven't found much - any help would be appreciated. Thanks!
... View more