I currently have a dataframe that I would like to collapse that has the following columns
Name - Attempt - Outcome1 - Outcome2 - Outcome3
I would like to reformat it into the following single dataframe
Name - Attempt - Outcome1
Name - Attempt - Outcome2
Name - Attempt - Outcome3
I've played around with melt() and cast() but I'm either not using them correctly or they are not the answer to the solution