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
