Forum Discussion
Elad_Magazanik
Nov 19, 2023Copper Contributor
Table transformation
Hi, does anyone have any idea on how to transform this table: To this table: Many thanks, Elad
Elad_Magazanik
Nov 20, 2023Copper Contributor
Thank you for the assistance.
Lorenzo
Nov 20, 2023Silver Contributor
You're welcome Elad_Magazanik
(Don't undertand why you marked as solution the post from peiyezhu that refers to another Data transformation using Power Query IMHO)
- PeterBartholomew1Nov 20, 2023Silver Contributor
Agreed. Both of your PQ solutions work perfectly, as does OliverScheurich's Lambda function solution.
My solution handles repeat items as separate objects.
- LorenzoNov 20, 2023Silver Contributor
I suspect @Elad_Magazanik has marked the "wrong" post by mistake...