Combining multiple rows of data into one row

Hi, I am trying to combine multiple rows into a single row - please find attached a copy of the data and an example of what we are trying to achieve with this. any help would be greatly appreciated.

Many thanks
Sarah

Alteryx Community.xlsx

Workflow

Datasets

Tips and Tricks

Transformation

Accepted answers

philipmannering

@SBow Please see attached for a potential solution,

combining multiple rows.yxmd

All comments

philipmannering

@SBow Please see attached for a potential solution,

combining multiple rows.yxmd

Perfect - thank you so much for your help!

philipmannering

You're welcome @SBow

Quick Links

Tags

This months top contributors

atcodedog05 19458

Qiu 15866

MarqueeCrew 13708

apathetichell 13703