How to repeat the List of items for each Category using Power Query

How to repeat the List of items for each Category using M-Query in Power BI

Scenario:

Suppose we have the sample of Product details as per below. In this sample we have 10 distinct Products and 3 unique Product Segments.

From this sample, we need to repeat the list of Products for each Product Segment.

We can achieve this Scenario, using the following M-Query (Power Query):

ProdListBySegment =

let

    Source = Product_Details,

    ProdSegmentList = List.Distinct(Source[Prod_Segment]),

    ProdNameList = List.Repeat(List.Distinct({Source[Prod_Name]}), List.Count(ProdSegmentList)),

    TableFromProdLists = Table.FromColumns(ProdNameList, ProdSegmentList)

in

    TableFromProdLists

Result:

Please Note:
I used above sample only to explain how this technique works. You can apply this technique for the right Scenario.

Thanks, Tamatam