Multiple column from single column

[LearnPowerBIAS]

Hi Friends,

I have a requirement, 

Input Table:

Source	Active	Participants	Total %	Assets
A	1	121	70443	4
B	3	222	22	3
C	4	555	3	8
D	2	888	19587	1
E	0	987	6962	2

This is the input data I have from a single table. 

Output Data:

A Active	Aparticipants	Atotal%	Aassets	Bactive	Bparticpants	Btotal%	Bassets	Cactive	Cparticpants	Ctotal%	Cassets	So On......
1	121	70443	4	3	222	22	3	4	555	3	8

This is the output need to acheive.  All data is coming from single table.

Apart from that few other coulmn will aslo get inserted in the output table. 

Please let me know how to bring this requirement. 

[Anonymous]

Hi @LearnPowerBIAS ，

Here I suggest you to try to create a matrix visual.

For reference: Create a matrix visual in Power BI - Power BI | Microsoft Learn

Result is as below.

Best Regards,
Rico Zhou

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

[LearnPowerBIAS]

I have someother feilds as well as input. With Matrix it is not possible. 

Source	Active	Participants	Total %	Assets	Parent	Child
A	1	121	70443	4	AAA	A12
B	3	222	22	3	BBB	B23
C	4	555	3	8	CC	C12
D	2	888	19587	1	DDD	D98
E	0	987	6962	2	EE	E45