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
Solved! Go to Solution.
@Simon1187
I think we need your CLEANSING DATA - duplicates.xlsx as input.
Sorry the last file I have attached was correct.
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
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?
Glad to help and would appreciate if you could mark it as accept 😁