Please help setup data to desired output

[jjbb]

Have this data, with several stores incoming data transactions. Please help split data by store name and transactions, so it matches attached image.

[BS_THE_ANALYST · Accepted solution]

@jjbb I never usually parse XML. How does this look:

[Shifty]

XML is gross to read. 😁

[jjbb]

Thank you BS_THE_ANALYST that was quick and optimal. Appreciate your help, you are a legend!! :)

[BS_THE_ANALYST]

@jjbb Thanks for the question! It was interesting to tackle 😎