Transform table

[joannasokolowska]

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

[binuacs · Accepted solution]

@joannasokolowska one way of doing this

[Qiu · Accepted solution]

@joannasokolowska 
I basically followed the way of @binuacs and use the RegEx instead to be more accurate and flexible, I hope 😁

[joannasokolowska]

Thank you guys for a quick help!

[Qiu]

@joannasokolowska 
Glad to help and thank you for the accept mark.