Combining Duplicate Columns with the different data in their rows

Hi All,

I currently have a spreadsheet that lists out all of our active clients and every type of transaction they have attempted and didn't complete, have completed, and are in the process of doing. In column B there is a list of all the client names but if the client has had multiple types of transactions, the name is listed in column B for every transaction. I want to be able to show just the client name and show every type of transaction they have attempted and what the outcome was in a horizontal fashion and only show the client name one time. I've attached the spreadsheet of data I'm working with. Any ideas? Thank you so much in advance!

The info will already be there. I am exporting the information from a CRM.