Unpivot multiple columns

Question

Hello Team,&nbsp;I have following dataPrinter NamePrint Job TitlePrint Job OwnerPrint DatePrint TimeStatus&nbsp;Material 1Material 1 UsageMaterial 2Material 2 UsageABCD1Part 1&nbsp;Anup7/3/202030:49:39SuccessABS161.659SM2910.025ABCD1Part 2Anup7/2/20207:11:23SuccessABS19.98SM297.168ABCD1Part 3Anup6/26/20208:34:40SuccessABS13.577SM295.555ABCD1Part 4Anup6/24/20205:22:42SuccessABS11.331SM294.051ABCD1Part 5Anup6/24/20205:37:46FailABS21.028SM292.615&nbsp;and I have been trying to simplify this table in below formPrinter NamePrint Job TitlePrint Job OwnerPrint DatePrint TimeStatus&nbsp;Material&nbsp;Material UsageABCD1Part 1&nbsp;Anup7/3/202030:49:39SuccessABS161.659ABCD1Part 1&nbsp;Anup7/3/202030:49:39SuccessSM2910.025&nbsp;can you help me unpivot this?&nbsp;Thank you,Anup

rajulshah · Answer

Hello&nbsp;Etre-Anup,Go to Advanced Editor &gt; Right click on 'Material 1' &amp; 'Material 2' fields &gt; Select 'Unpivot Columns'.You will get your desired result.&nbsp;Hope this helps. Let me know if it doesn't.

amitchandak · Answer

Etre-Anup , refer to these 
https://radacad.com/pivot-and-unpivot-with-power-bi
https://kohera.be/blog/power-bi/how-to-unpivot-twice/
Transpose : https://yodalearning.com/tutorials/power-query-helps-transposing-data/

Forum Discussion

Unpivot multiple columns

2 Replies

Related content

Unpivot Column

Advanced unpivoting multiple columns

Unpivot multiple columns

Unpivot Multiple Columns

Unpivot columns

Printer Name	Print Job Title	Print Job Owner	Print Date	Print Time	Status	Material 1	Material 1 Usage	Material 2	Material 2 Usage
ABCD1	Part 1	Anup	7/3/2020	30:49:39	Success	ABS	161.659	SM29	10.025
ABCD1	Part 2	Anup	7/2/2020	7:11:23	Success	ABS	19.98	SM29	7.168
ABCD1	Part 3	Anup	6/26/2020	8:34:40	Success	ABS	13.577	SM29	5.555
ABCD1	Part 4	Anup	6/24/2020	5:22:42	Success	ABS	11.331	SM29	4.051
ABCD1	Part 5	Anup	6/24/2020	5:37:46	Fail	ABS	21.028	SM29	2.615