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)

HI @ISBS_ROBOT

you can try this way hope it will help for you

output:-
image

Bro,
Can you please share me the workflow??!!

@ISBS_ROBOT

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

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.