Forum Discussion
Rolling Join in Power Query
Hi peterhui50
Something like this where all Transactions are in the same field? This keeps it at 1 record per Name, but you could also extract the data so that each Transaction is a separate record for that Name.
Regards
Phil
Hi peterhui50
Something like this where all Transactions are in the same field? This keeps it at 1 record per Name, but you could also extract the data so that each Transaction is a separate record for that Name.
Regards
Phil
Thank you! I think after I can just split those up and rejig them. Ideally I was hoping that they would be in two rows.
It's all good, you've done a lot on this already. Thank you!
Hi peterhui50
No worries.
To get the transactions on separate rows, right click the TRansactions column header -> Split Column -> By Delimiter.
Choose Comma as the delimiter, and open the Advanced options, select Split into Rows
Which gives you this
Regards
Phil