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

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: 

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

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.