Preparations

[Simon1187]

Hi everyone! 

Hi @CharlieS 

Hi 

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 

[Qiu]

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

[Simon1187]

Hi @Qiu 

Sorry, I have attached. 

[Qiu]

@Simon1187 
Now I am officially confused.

What is the connection between this two data?

[Simon1187]

Sorry the last file I have attached was correct. 

[Qiu]

@Simon1187 

So the file you attached last is the output you desired?

Then the input file?

The one showing in your sample workflow is *CLEANSING DATA - duplicates.xlsx*, but we dont have it I think.

[Simon1187 · Accepted solution]

@Qiu 

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

[Qiu · Accepted solution]

@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?

[Simon1187 · Accepted solution]

@Qiu 

Thank you very much for help. 

[Qiu · Accepted solution]

@Simon1187 

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