merge rows

[#1]

I have the below table

Name	3-support	onemore
a	table2-support3	er
n	e	rt
c	y	ty
d		no
d	oh

I want to merge the rows based on the Name for e.g.

The last 2 rows should be merged in one row as

d        oh      no

Can someone please help understand how I can accomplish this? I tried doing a self join but that didn't get me the results I want. Thanks in advance for your help.

Thanks,
Samira

[#2]

Going back to the example you used for the solution, you did a load inline for source table. I am not doing a load inline but instead am loading from a spreadsheet. And during the load I am doing a if(match) to get data into separate columns. so based on your solution, if I drop the source table at the end,  won't I lose the new columns that I am creating during my initial load of the source table?

Sorry if this is getting complicated. I will start a new discussing but it will be an extension of this post.Thanks for all your help.

Thanks,

Samira