http://speedy.sh/Hc3AV/test123.xlsx
I am looking to separate out data provided on a spreadsheet. The location code is currently given in one column, but the data and date are both provided in the same column. Is there a way to separate out these two things? Most of the time there is a row space between the two types of data, but sometimes there is not. My ultimate goal is to have location, date, data all in separate rows w/o any unnecessary empty cells.
I am looking to separate out data provided on a spreadsheet. The location code is currently given in one column, but the data and date are both provided in the same column. Is there a way to separate out these two things? Most of the time there is a row space between the two types of data, but sometimes there is not. My ultimate goal is to have location, date, data all in separate rows w/o any unnecessary empty cells.