Transpose only selected rows as columns.

[Kavya132017]

Hi everyone,

I have a data where a Project can be linked to an event or can be a solo Project without any event linked to it. Currently, all the data is in q single table divided as rows. I need to get event attached to project in a new column next to Project.

Whenever there is an event, it is present right below the linked project. A project can have more than 1 event. If there's no event related to it, it's just the project name.

Attached sample data. Any help is appreciated, Thank you!

[JosephSerpis · Accepted solution]

Hi @Kavya132017 i've come up with one approach which use the Multi-row tool to create a join key to join events and Projects together and then unions all the data together to produce your expected output.

[Kavya132017]

Thank you @JosephSerpis . This worked!