Transform duplicate rows into columns

[PowerBITestingG]

Hello,

So basically I got a table with 2 columns, the Type column can contain many different values

Name	Type
a	Trek
a	Agrek
b	Grob
b	Job

So I need to split them into this:

Name	Type1	Type2	Type3-99
a	Trek	Agrek	etc
b	Grob	Job	etc

Any ideas? I am stuck

[AntonioM]

You could do it in Power Query. First, you'd want to use Group by to concatenate the text values. 

= Table.Group(#"Source", {"Name"}, {{"Type", each Text.Combine([Type], ","), type nullable text}})

 Then you could split that by the commas

= Table.SplitColumn(#"Grouped Rows", "Type", Splitter.SplitTextByDelimiter(",", QuoteStyle.Csv), {"Type.1", "Type.2"})

Which should give you 

That should give you as many columns as you need. If a name gains more types, you'd need to ok the split column step again. 

[PowerBITestingG]

---

Which should give you 

That should give you as many columns as you need. If a name gains more types, you'd need to ok the split column step again. 

---

Thats the issue I am trying to solve, I cant know how many they are the data set is too big and it keeps changing