Advanced Data Transportation in Power Query Using Table.Group and Table.Pivot

In this Power Query tutorial, we solve Challenge 15, where the goal is to transform a table so that information for each product appears in its own individual row — exactly as requested by the manager!
We’ll use Table.Group to organize the data and Table.Pivot to restructure it neatly.
Perfect for anyone wanting to master table transformations in Power Query!

00:00 Introduction
01:30 Load Into Power Query
01:45 Grouping the rows
02:20 Add Index
03:45 Pivot Table

[Excelambda]

Great!! Simple formula solution:
=LET(
a, B3:B12,
b, C3:E12,
DROP(PIVOTBY(a, SCAN(, SEQUENCE(ROWS(a)), LAMBDA(v, i, IF(INDEX(a, i) = INDEX(a, i - 1), v + 1, 1))), b, SINGLE, , 0, , 0), 1)
)

[IvanCortinas_ES]

Wonderful solution, Omid. I think in this case it's easier to do it with Power Query than with formulas. Thanks for sharing.

[kazembase]

ما که از این شماره گذاری ویدئو هات و ترتیبش سر در نیاوردیم هرچی هم سوال می‌کنم فایده نداره🤦‍♂️