Preparations

Hi everyone!

I hope you are well.

I want to remove duplicates in rows and columns and shape the unique the data in previous format. Could you please help me. I have attached the workflow and data.

Thank you very much for your help.

Thanks,

Simon

Duplicate_Rows.yxmd

Data 1 .xlsx

Preparation

Accepted answers

Simon1187

@Qiu

The last file is as input file. I want to remove duplicates in rows.

Data 1 .xlsx

Qiu

@Simon1187
Thank you for the detailed information and now I think I got your idea.

Just confim the P5 in 2nd row should also be null, right?

0429-Simon1187.yxmd

Simon1187

@Qiu

Thank you very much for help.

Qiu

@Simon1187

Glad to help and would appreciate if you could mark it as accept 😁

All comments

Qiu

@Simon1187
I think we need your CLEANSING DATA - duplicates.xlsx as input.

Simon1187

Hi @Qiu

Sorry, I have attached.

Quick Links

Unanswered
Community Events
Groups

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703