DanaScully
New Member
- Joined
- Sep 20, 2017
- Messages
- 6
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:
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.
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.