Structuring your data is extremely important. Comparable information should be in comparable cells to be able to compare and calculate.
So first make a good spreadsheet design.

Then either:
- reimport from some other system
- retype or copy/paste/edit individual cells
- use character string functions to extract subfields if data is structured enough
- write your own extract functions if data is not structured enough to work with standard formulas

This could be a lot of work. This is a simplified example of one of the Software Engineering rules: "First think, than do. If you don't think before doing, that might mean a lot of work to redo."
Lesson learned?

Hope this helps.