Transform lay out table in power query

[Anonymous]

Good day,

I have a question about the lay out of a table in my report.

Originally, the lay out of the table is as follows:

adres_cod	creditor	disc
ACD000	AMS000	0
ACD000	AMS004	0
ACD000	CAR700	0
ACD000	DAI110	0
ACD000	DEL020	0
ACD000	GRE062	0
ACD000	NOO520	0
ACD000	SEA050	0
ACD000	STA000	0
ACD000	STA001	0
ACD000	THE000	0
ACD000	THE995	0
ACD000	WES050	0
KKK000	AMS000	0
KKK000	AMS001	5
KKK000	AMS004	5
KKK000	CAR700	5
KKK000	DAI110	0
KKK000	DEL020	0
KKK000	GRE062	0
KKK000	NOO520	0
KKK000	SEA050	0
KKK000	STA000	0
KKK000	STA001	0
KKK000	THE000	0
KKK000	THE995	5
KKK000	VLA010	0
KKK000	WES050	0

I want to automatically transform this table to below lay out.

Is there a way to do so?

Thanks!

John

adres_cod	AMS000	AMS001	AMS004	CAR700	DAI110	DEL020	GRE062	NOO520	SEA050	STA000	STA001	THE000	THE995	VLA010	WES050
ACD000	0		0	0	0	0	0	0	0	0	0	0	0		0
ACS000	0	5	5	5	0	0	0	0	0	0	0	0	5	0	0

[amitchandak · Accepted solution]

@Anonymous , Are trying to unpivot creditor, disc.

unpivot

https://radacad.com/pivot-and-unpivot-with-power-bi

[Anonymous]

@amitchandak ,

Great, just what i was looking for!

Thanks a lot, John