How to display row data in one column for each unique identifier

[suzannelomanto]

Hi, I have a business objects v4.3 report which has a column for the person ID and 4 columns that show episode ID's, similar to this

What I'm trying to do is this

I have tried googling this, but can't seem to come up with a solution, is there a way to do it. Thank you in advance.

[AlexGourdet]

Thank you for visiting SAP Community to get answers to your questions. Since this is your first question, I recommend that you familiarize yourself with Community Q&A, as the overview provides tips for preparing questions that draw responses from our members.

Should you wish, you can revise your question by selecting Actions, then Edit.

By adding a Picture to your profile you encourage readers to respond.

Regards,

Alex