Data from Excel spreadsheet into condensed Excel Template

I have a spreadsheet that I download from an online database each week.  I want to take that information and condense it into more usable data.  I want to combine date/time columns, and three text columns into one.  Typically, two columns are blank with one having data, but each row can have data in different columns (i.e. H1 has data, then I2, then H3, then J4, etc).  Each week, the number of rows will be different.  I want to be able to sort the data by a couple columns.  

Before I do a bunch of research and testing, I want to make sure this is even possible!  The database online is not modifiable at all, and it is not particularly user friendly (I can only export 10 columns of data, or I have to wait up to 24 hours to get my information).  I was thinking a macro of some sort, but the combining of the text columns, I can't copy the formula - it stays absolute vs relative.

Thanks in advance,
Stephanie Foster