Power Query Challenge 16: Transform Long Table into Wide Table Structure - Advanced Use of Pivoting

[@Excelambda]

Great challenge!! Great PQ solution !!
Form alternative:
=LET(
a, B3:B15,
b, C3:C15,
p, DROP(PIVOTBY(a, SCAN(0, a = "Name", SUM), b, ARRAYTOTEXT, , 0, , 0), 1),
TRANSPOSE(SORTBY(p, XMATCH(TAKE(p, , 1), UNIQUE(a))))
)

[@PowerMquery]

Thanks for sharing your solution

[@IvanCortinas_ES]

Excellent solution Omid. Thank you!!!

[@PowerMquery]

welcome

[@kkravch]

Great content

[@PowerMquery]

welcome

[@henrylokrit232]

Insightful

[@PowerMquery]

You are welcome

[@rrrraaaacccc80]

👍💯

[@PowerMquery]

Thanks