Data transform

[DataPirate26]

Hi, 

Can anyone help me to get the Desired output from the input Data that is attached below. I have attached 2 text inputs one has the Input and the other has the desired output required. Please help . Its urgent. 

[DataNath · Accepted solution]

Can you explain the logic behind this? I've attached a solution that works but it's essentially just bruteforced to achieve your desired output, rather than necessarily following particular rules to get what you want every time.

[binu_acs · Accepted solution]

@DataPirate26 Another way of dong this with the help of the summarise tool