i want to to get data with this style
remove duplicate TC Name & Add owner & Status to the first result on new column as below
removed dublicate test case name to be as below
it can be achived with grouping the data on TC Name and processing the group members
for the GStatus we would recommend to recheck the requirements for the case that not all G Status values from the group memebrs are the same and how to handle e.g. concat…