Transpose data columnwise

[@BillSzysz1]

Thanks for video, Ashish.
I think we can do that in three steps
let
Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
GroupRows = Table.Group(Source, {"Project ID"}, {{"tbl", each _[Employee], type list}}),
LastStep = Table.FromColumns(GroupRows[tbl], GroupRows[Project ID])
in
LastStep
Regards :-)

[@excelenthusiasts]

Bill Szysz Hi, Thank you for sharing this. I will try it and revert.