Grouping by Column

[needanswers101]

Hi, 

I need to group the below dataset by Role: Name while keeping the account numbers. 

The desired end state is to have one line with the SAP Account Number, Account Name, Joel Vaz under a column labelled CSP - Sales Exec Remote and Louann Amm under a column labelled CSP - District Director Remote Sales. So I'm looking for one line with

[KeyurPatel14]

 Hi @needanswers101 ,
Can you please provide sample output for better understanding?