Rows to column

[noopurjain]

Hello,

I have two columns in my data (Accounts and codes), For one account there are multiple codes. I need all the codes in single row with respect to one particular.  account. I have given the example in attached excel. How can I achieve this?

[ShankerV · Accepted solution]

Hi @noopurjain 

Please find the expected solution.

[binuacs · Accepted solution]

@noopurjain One way of doing this