Hi colleague,
I would like to ask you for an advice regarding transforming table.
I have dataset as below (Training, A, Training B, etc are column names, and there are about 70 columns like this and could dynamically change). Also the list of emails will be growing.
Training A | Training B | Training C | Training D |
50 | 50 | 160 | 20 |
2022-09-06 | 2022-07-09 | 2022-01-05 | 2022-06-09 |
tom.mayer@xyz | tom.mayer@xyz | peter.roll@xyz | ann.wilins@xyz |
peter.roll@xyz | kate.billing@xyz | ||
matt.ron@xyz | |||
alice.wood@xyz |
And as an output I would like to see it structure like this:
Training A | 50 | 2022-09-06 | tom.mayer@xyz |
Training A | 50 | 2022-09-06 | peter.roll@xyz |
Training B | 50 | 2022-07-09 | tom.mayer@xyz |
Training B | 50 | 2022-07-09 | kate.billing@xyz |
Training B | 50 | 2022-07-09 | matt.ron@xyz |
Training B | 50 | 2022-07-09 | alice.wood@xyz |
Training C | 160 | 2022-01-05 | peter.roll@xyz |
Training D | 20 | 2022-06-09 | ann.wilins@xyz |
Thank you in advance!
Asia
Solved! Go to Solution.
@joannasokolowska
I basically followed the way of @binuacs and use the RegEx instead to be more accurate and flexible, I hope 😁
Thank you guys for a quick help!
@joannasokolowska
Glad to help and thank you for the accept mark.