How to split one column into multiple columns based upon values?

[cinsbox]

Hi I would like to see if anyone can help with splitting one column into multiple columns using Power Query.  

I am pulling a list of customers using from SQL database, the list looks like the following: 

Customer ID	Name	Type
123	Name1	Addressee
123	Name1	Salutation
234	Name2	Addressee
234	Name2	Salutation

Is there any way to restructure the data using Power Query so the data looks like this? 

Customer ID	Name	Type1	Type2
123	Name1	Addressee	Salutation
234	Name2	Addressee	Salutation

I would like how to rid of two rows per customers and also split the text value under Type into separate columns.  Any help is appreciated!  Thank you. 

[wdx223_Daniel · Accepted solution]