Why does my data take up multiple fields??
In this spreadsheet, some of my data sprawls across multiple columns. For example the date takes up columns A, B, and C. I think it was done this way for visual purposes, but I'm trying to crunch some numbers and this format does not work for me. Is there a way I can condense my data down into single columns each?
I want the date in column A only, the next number in column B only, and the address in column H only.
Please see attached file for an example. It is only a sample; the actual document is thousands of records, and editing the source is not an option.
Thanks in advance!
|