Unreliable data due to sorting prior to pasting?

[DanaScully]

Hi

I'm currently working on a spreadsheet which looks as though it has had some columns sorted individually on a parent sheet prior to pasting onto this sheet. For example, when sorting surnames A-Z, the corresponding street names are also sorted A-Z, and the DOBs are also sorted smallest-largest. For example:

Surname	DOB	Street
Armson	01/01/2000	Anchovy Street
Bellson	02/01/2000	Bell Road
Cotson	03/01/2000	Cress Lane

When I received the spreadsheet there was a custom sort in place for ID number. I removed this filter and the data is nonsensical, however way I try to sort it.

Am I right in thinking that whichever methods I use to try to manipulate and correct this data, if it was pasted incorrectly at the source (by the spreadsheet author), there is no way I can fix it?

Thank you in advance for any help.

 

[ExcelGzh]

You are correct. It is impossible to correctly re-align the Surnames, DOBs and Streets. It's a bin job.

 

[DanaScully]

You are correct. It is impossible to correctly re-align the Surnames, DOBs and Streets. It's a bin job.

Thank you! I thought that was the case.