in the image below there is a table i have downloaded, the information is spread accross multiple rows and i want it all to be on the same row as i have done for the first entry then i need to delete the duplicate name values in the first column

any ideas?

thanks in advance

Untitled.png