Combine Rows and show in a Table

Thanks for the reply from amitchandak , please allow me to provide another insight:

Hi, gssarathkumar 

We currently have two solutions, each with its own drawbacks. You can choose based on your needs:

1.Firstly, you can merge the two tables and create an index, keeping only the first one:

First, create an index column in Power Query:

let
    Source = Table.NestedJoin(Table, {"Engagement"}, #"Table (2)", {"Engagement"}, "Table (2)", JoinKind.RightOuter),
    #"Expanded Table (2)" = Table.ExpandTableColumn(Source, "Table (2)", {"Topic", "Owner", "Implications", "Action Required", "Timing"}, {"Table (2).Topic", "Table (2).Owner", "Table (2).Implications", "Table (2).Action Required", "Table (2).Timing"}),
    #"Grouped Rows" = Table.Group(#"Expanded Table (2)", {"Engagement"}, {{"Count", each Table.AddIndexColumn(_, "Index", 1, 1, Int64.Type)}}),
    #"Expanded Count" = Table.ExpandTableColumn(#"Grouped Rows", "Count", {"SLA & Obligation Remarks", "Stability & Availability Remarks", "Security & Vulnerability Remarks", "Customer Sentiment", "Table (2).Topic", "Table (2).Owner", "Table (2).Implications", "Table (2).Action Required", "Table (2).Timing", "Index"}, {"Count.SLA & Obligation Remarks", "Count.Stability & Availability Remarks", "Count.Security & Vulnerability Remarks", "Count.Customer Sentiment", "Count.Table (2).Topic", "Count.Table (2).Owner", "Count.Table (2).Implications", "Count.Table (2).Action Required", "Count.Table (2).Timing", "Count.Index"})
in
    #"Expanded Count"

Next, use the following calculated column:

engagement1 = 
VAR FIRST=CALCULATE(MIN('Merge1'[Count.Index]),ALLEXCEPT('Merge1','Merge1'[Engagement]))
RETURN IF('Merge1'[Count.Index]=FIRST,'Merge1'[Engagement],BLANK())

There is a link to a similar issue:

https://community.fabric.microsoft.com/t5/Desktop/Group-by-ID-Skip-Aggregation/td-p/3976285

Here's my final result, which I hope meets your requirements.

2.Secondly, you mentioned using the matrix view:

You only need to modify the matrix settings as shown in the image below:

ere's my final result, which I hope meets your requirements.

Please find the attached pbix relevant to the case.

 
Of course, if you have any new ideas, you are welcome to contact us.
 

Best Regards,

Leroy Lu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.