Formatting a table column into multiple lines

Question

Im looking to either do this in DAX or Power query to create a new table where some of the colums need to become a row and duplicate some of the information in the row against the column.&nbsp;Maybe easier to show in the example&nbsp;Original Data&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;NameStatusRatingScoreID1ID2ID3ID4ID5DateABCExpiredLow1302345212123123131224&nbsp;1/01/2020EFGAcceptedHigh154567&nbsp;&nbsp;&nbsp;&nbsp;1/01/2020HIJAcceptedMedium120678908&nbsp;&nbsp;&nbsp;1/01/2020KLMAcceptedHigh110&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1/01/2020&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Outcome&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;NoNameStatusRatingScoreDate&nbsp;&nbsp;&nbsp;&nbsp;23452ABCExpiredLow1301/01/2020&nbsp;&nbsp;&nbsp;&nbsp;12123ABCExpiredLow1301/01/2020&nbsp;&nbsp;&nbsp;&nbsp;1231ABCExpiredLow1301/01/2020&nbsp;&nbsp;&nbsp;&nbsp;31224ABCExpiredLow1301/01/2020&nbsp;&nbsp;&nbsp;&nbsp;4567EFGAcceptedHigh152/01/2020&nbsp;&nbsp;&nbsp;&nbsp;678HIJAcceptedMedium1203/01/2020&nbsp;&nbsp;&nbsp;&nbsp;908HIJAcceptedMedium1204/01/2020&nbsp;&nbsp;&nbsp;&nbsp;

saminogic · Accepted Answer

Hi Anonymous&nbsp;,&nbsp;You can below steps to achieve the required outcome,Open your table in Power Query Editor as shown in below screenshot,Select the columns &gt;&gt; ID1, ID2, ID3, ID4 &gt;&gt; click on transform menu from menu bar &gt;&gt; Click on Unpivot Selected Columns option. Please refer to the below screenshot for the same.This will create two new columns as Attribute and Value. Rename the Value Column as “No”.Now Close and Apply the changes and add the table on the report with required columns as shown in the below screenshot.Thanks!Inogic Professional Services DivisionPower Platform and Microsoft Dynamics 365 CRM Development – All under one roof!Drop an email at crm@inogic.comServices:&nbsp; http://www.inogic.com/services/Power Platform/Dynamics 365 CRM Tips and Tricks:&nbsp; http://www.inogic.com/blog/

Forum Discussion

Formatting a table column into multiple lines

1 Reply

Related content

Dynamical conditional formatting for multiple columns

Conditional Formatting a Matrix with multiple columns

Sequential Order column based on multiple criteria

Multiple date formats in column

Custom Conditional Formatting for Multiple Columns?

Original Data
Name	Status	Rating	Score	ID1	ID2	ID3	ID4	ID5	Date
ABC	Expired	Low	130	23452	12123	1231	31224		1/01/2020
EFG	Accepted	High	15	4567					1/01/2020
HIJ	Accepted	Medium	120	678	908				1/01/2020
KLM	Accepted	High	110						1/01/2020


Outcome
No	Name	Status	Rating	Score	Date
23452	ABC	Expired	Low	130	1/01/2020
12123	ABC	Expired	Low	130	1/01/2020
1231	ABC	Expired	Low	130	1/01/2020
31224	ABC	Expired	Low	130	1/01/2020
4567	EFG	Accepted	High	15	2/01/2020
678	HIJ	Accepted	Medium	120	3/01/2020
908	HIJ	Accepted	Medium	120	4/01/2020