Solution in Table Formatting

Question

Good evening, everyone.I would like to ask for your wisdom here.I am exploring methods to create "Formatted Table 2" from the following "Source Table" using Power Query and DAX expressions in Power BI Desktop.[Source Table]Name Code&nbsp;NameDepartment Code1000Mr. AA000,B100,C1001010Mr. BA000,B100,C200,D000,F0001020Mr. CX000,Y100↓[Formatted Table 1]&nbsp;Name CodeNameDepartment Code.1Department Code.2Department Code.3Department Code.4Department Code.51000Mr. AA000B100C100&nbsp;&nbsp;1010Mr. BA000B100C200D000F0001020Mr. CX000Y100&nbsp;&nbsp;&nbsp;↓[Formatted Table 2]Name CodeDepartment Code1000A0001000B1001000C1001010A0001010B1001010C2001010D0001010F0001020X0001020Y100&nbsp;I managed to create "Formatted Table 1" from "Source Table" using Power Query, but I am unsure how to format "Formatted Table 2".I am open to ideas on how to format "Formatted Table 2" either from "Formatted Table 1" or directly from the "Source Table" if possible. Any guidance on achieving this would be greatly appreciated.

ritaf1983 · Accepted Answer

Hi&nbsp;SideWinderTel&nbsp;You can get the last form table with the split-to-rows functionality in the power query.

&nbsp;
result

pbix is attached
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.

Forum Discussion

Solution in Table Formatting

2 Replies

Related content

Formatting Value of Table

DAX SOLUTION NEEDED

Table Call Value Formatting Options

Formatted Table Reversing Causes Errors

matrix table format--i want table in below format

Name Code	Name	Department Code
1000	Mr. A	A000,B100,C100
1010	Mr. B	A000,B100,C200,D000,F000
1020	Mr. C	X000,Y100

Name Code	Name	Department Code.1	Department Code.2	Department Code.3	Department Code.4	Department Code.5
1000	Mr. A	A000	B100	C100
1010	Mr. B	A000	B100	C200	D000	F000
1020	Mr. C	X000	Y100