How to split table and keep all columns with correct information?
I'm trying to split a table by "Method", so each method becomes a new column, with the values associated. But I want to keep all the other columns, ID and Name.Initial table:Desired split: or Either of the formats pictured above would work for my purposes. However using the split function:Which gives me wrong results:For example, ID = 3, B = 222 was done by Jon, not Alice. So the values for ID and...