transpose multiple data stored in rows into columns

[omar_velor]

Hi all,

Currently learning Alteryx, and wondering how can I achieve the following task.

I have a table with some rows storing multiple data, separated by a space. 

ID	Country	Age	Height	Weight
1	UK	11	60 61 62	70 71 72
2	DE	12	63 64 65	73 74 75
3	FR	13	66 67 68	76 77 78

How can I transpose the rows data into columns? I am trying the get the table below,

ID	Country	Age	Height	Weight
1	UK	11	60	70
1	UK	11	61	71
1	UK	11	62	72
2	DE	12	63	73
2	DE	12	64	74
2	DE	12	65	75
3	FR	13	66	76
3	FR	13	67	77
3	FR	13	68	78

I have a feeling this has been asked already, but cannot find the corresponding post. Please guide me to it if already exists.

[geraldo · Accepted solution]

@omar_velor 

Here is an example workflow