Aug 13 2020 08:10 AM
Hello,
I have a large excel spreadsheet that was matched English to French translation and then was tampered with and the English column was filtered A to Z making it so the English does not align with the French anymore. How do I make it so the English realigns with the French?
Thank you
Aug 13 2020 08:18 AM
Aug 13 2020 08:18 AM
I fear the answer may be "laboriously."
I've had the experience myself of sorting a table and having that mess up some of the relationships between columns, even though the entire table was sorted. I can imagine, therefore, that if all that was sorted (not filtered) was the English Language column--although one might ask "Why?"--that it can't just be "un-sorted."
UNLESS...were there any other columns of data, categories perhaps, other identifiers of the types of phrases or words, that could be used in a step-wise fashion to start to restore?
In other words, what was the overall structure of the original spreadsheet? Is it possible to post a sample?
Aug 13 2020 08:23 AM