I have a df swith a column named 'Names'and a column named 'Groups' that has 30 rows. The structure is like :
name1 group1
name2 group1
name3 group1
name4 group2
name5 group2
name6 group2
... ...
name28 group10
name29 group10
name30 group10
I want to create 3 columns with the names 'Extra name 1','Extra name 2','Extra name 3'.
I want the column 'Extra name 1' to have the values name1,name4,name7,name10 ...name28.
I want the column 'Extra name 2' to have the values name2,name5,name8,name11 ...name29.
I want the column 'Extra name 3' to have the values name3,name6,name9,name12 ...name30.
Desired result :
Groups Extra names 1 Extra names 2 Extra names 3
group1 name1 name2 name3
group2 name4 name5 name6
... ... ... ...
group10 name28 name29 name30
