Try this
Using an intermediate sheet for all helper columns ("NoDuplicates")
In Sheet "NoDuplicates" A2
Drag Across as required, then Down
This, as the sheet name suggests, should remove duplicate values from your source sheet, and also convert all numbers to text.
This then means that we can now use one formula for Text and Numeric columns to "Remove Blanks" (Not strictly true, it removes duplicates, all of which now should be blanks, hence row 2 is blank.)
In Sheet "NoBlanks" A2
Drag Across as required, then Down
You can now copy this sheet and Paste Special > Values to your desired sheet, and convert the "numeric" columns back to numbers (Use Text to columns and then format the column "General").
There must be a way to do this without the helper sheet, but I can't see an easier way.
Maybe some of the formula cavalry will provide a better answer....
Hope this helps
Bookmarks