Convert data lay out

[jwi1]

Good day all, I have the following question.

Below is table_1.

I want to convert that table in the lay out of table_2.

Is there any option in Power BI to do so?

Thanks for your kind assistance, John

table_2

Equipment No	Mode 43	WorkOrder No mode 43	VendorRef No mode 43	Mode 49	WorkOrder No mode 49	VendorRef No mode 49
CNIU2212712	40,13	70475555	0080505820	14,38	70475778	0080505830
CNIU2214850				14,38	70499772	0087328110
CNIU2214989	59,13	70593778	0087324030

table_1

Mode	Equipment No	Total	WorkOrder No	VendorRef No
43	CNIU2212712	40,13	70475555	0080505820
49	CNIU2212712	14,38	70475778	0080505830
49	CNIU2214850	14,38	70499772	0087328110
43	CNIU2214989	59,13	70593778	0087324030

[v-jiascu-msft · Accepted solution]

Hi @jwi1,

Please download the demo from the attachment. You can click or double-click the "Applied steps" to see the details. BTW, this may not be a good idea. What if there are thousands of Modes?

=[Attribute] & " " & Text.From([Mode])

Best Regards,
Dale

[jwi1]

Good day!

Thanks for the reply, works dine for me.

John