Remove duplicate & add value to new columnt

dears i tried lot solutions and downloaded lot files from help forum all failed
please help urgent
i extract below data

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

Test Case Name G Status Tester Status Tester Status Tester Status
B01-6.1.6.TEST.CASE:.Create.Issue…Creator…[Failure.scenario] Pased Mahmoud Passed Ramy Passed Mohamed Passed

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…