Power query - Power Bi - Dhis2

Question

I need help to transpose the first column in line which is added side by side with the other two columns. How to specify it in the api other than it is parameter that I must specify that the result gives what I wanted to have?

The current result

Data	Organization	Periode	value
text1	name org1	month	value1
text2	name org2	month	value2
....	.....	.....	.....

the result I want

Oganization	Periode	text1	text2	text...
name org1	month	value1	value2	...
name org2	month	value1	value2	...

let Source = Csv.Document(Web.Contents("https://ministere-sante.mg/api/29/analytics.csv?dimension=dx:toUMbcnAgGN;O1W97xlGqBZ;arxPOcQhanb;dn8pVWUHojB;FvLKwx96Kv0;q87CgC2m7fZ;NU6LJrW5OtP;rw8lpwb5j5G;oWA1W7mmuba;qHDVI4FRFjE;qtKuAZgaMU0;rm102gbKzBZ;ACiHvHoBVtZ;IeIcIkISFW4;naBJZSepUeV;Qi1WRFJoSnU;Swv8DdBhJvC;NnYKpAzraXX;T0kBIwfDa5N;o5kVh4kRFF9;JAX5HOu665U;QkW2vpJn1z5;lhQWQlxrzOv;wiw3Y0Zkjii;uyey4mCGZLz;GPnoGnyocHS;sx7TSP921al;s0mlmmPbCdq;f3fhveMBAt2;cmaAWx5VuEx;aGmAt9Ovc57;LVZ0zsPVm3f;gr4bKti3JEw;cMN7aHkXHhs;BFeLG7TNOvq;A9PF5ZTUGPN;tHivnx60q8q;wdPJGHpacCb;M5hPC2GC9N8;bMxzvvXKsGH;Ofuxl3WRHb0;QMSuZWQIf8a;QJ6ujwA2gko;jgNrV7s1AiP;MT5wClwhTPx;ALvAHqLDm9c;HnYt4ZXti24;QiNO2NlJJNc;SGZoMo3Hx4j;Qc94kxm2YJe;i6RTvjFSehw;PP68mDkB94t;sDQlOpLyZiR;u0Akq9GFioM;dzwW7D68fMo;wNTH1o9J9QV;xdxcfEcIPIP;QcyVv7YjiZs;vr8IFPHqD2w;HfQiHEQTJ0g;hmpaTGAqd0z;D7RcnVq5INU;QAfFgIPHa3s;eXYjyu0ey8I;QuufqC3FcDL;TwYb8CZJtCz;t1ErzIjc6Rq;veCj7xnZiZf&dimension=ou:qwzcYsSzL7k;LEVEL-5&dimension=pe:LAST_MONTH&displayProperty=NAME&outputIdScheme=NAME%22),%5BDelimiter=%22,", Columns=4, Encoding=65001, QuoteStyle=QuoteStyle.None]), #"En-têtes promus" = Table.PromoteHeaders(Source, [PromoteAllScalars=true]), #"Type modifié" = Table.TransformColumnTypes(#"En-têtes promus",{{"Data", type text}, {"Organisation unit", type text}, {"Period", type text}, {"Value", type text}}) in #"Type modifié"

Answer 1

Try

#"Pivoted Column" = Table.Pivot(#"PriorStepNameGoesHere", List.Distinct(Source[Data]), "Data", "value")