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
