Remove duplicates from all columns.

Hi all

I have been looking around for a code to remove duplicates from multiple columns however none appear to do what I need.
Even the Remove Duplicate from the data tab does not help me.

What I have:
There are several columns of numbers which are separated by a full stop.
The number of column's will not be able to be predetermined.

What I need:
I need a vba code that will look at the entire sheet and remove any duplicated cells and leave only one of the cells (which was duplicated).
Then To save space on the sheet, I would also like it to re-order the sheet from smallest to largest. (this would move cells to different columns if needed)

attached is an example