Parse more than 1 column at the same time

[beacc]

Hi everyone,

I need a away to transform this input:

  

Amount	Date	Code
123.98|113.13	2023-01-11|2023-01-17	TB|TB
10000.00|19606.00|10000.00	2023-05-30|2023-06-30|2023-04-24	TB|TB|TB

To this output:

Amount	Date	Code
123.98	2023-01-11	TB
113.13	2023-01-17	TB
10000.00	2023-05-30	TB
19606.00	2023-06-30	TB
10000.00	2023-04-24	TB

The thing is: 

- The values will always be different;

- Sometimes I may have to separate in two rows but other times can be less or more, according how many "|" I have.

You can check the example attached. I hope you can clarify me.

Thank you,

Beatriz

[binuacs · Accepted solution]

@beacc One way of doing this

[beacc]

Thank you so much 😀