Remove duplicate & add value to new columnt

welcome to the forum

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…