Excel writing data in another column based on one column

Hello All,

I have an excel file, in which one column “Coverage” has data like “Private Cars Package” with duplicates. for each and every row with that name I need to write “comprehensive” in column “Segment Class”.
I have attached file. Need to write the data in column W as mentioned. Please help me sorting the issue.
Insurance_Data.xlsx (11.8 KB)


you can try this way hope it will help for you


Can you please share me the workflow??!!


Xaml :- data in another column based on one column.zip (2.0 KB)

@ISBS_ROBOT Let me know its working or not

Thank you bro,
It’s working.

1 Like