iterative Macro Hierarchy

Question

Hi

I have following dataset

ParentChildA1X1A1X2A1X3A1BBY1BY2CS1CS2CS3RZ1DE1DE3Y1L1Y1L2Z1J7

Expected Output:

I have build a iterative macro for the output, I'm looking for optimized workflow

A1X3  A1X2  A1X1  A1BY1Y2BY1`L1 BY2  CS1  CS2  CS3  RZ1J7 DE1  DE3  Y1L1  Y1L2  Z1J7

BRRLL99 · Answer

the issue in my original data I have

same data points in both parent and child items

please let me update the data again

philipmannering · Answer

Please try the solution I posted here: https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Hierarchy-data-with-Iterative-Macro/td-p/1110189

If this is not what you need then let me know why!