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
StephanieFosterAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

regmigrantCommented:
it would be best if you could post an example but nothing you are asking for is impossible and on the surface it doesn't seem difficult

to simplify the handling of multiple rows select the entire data set and change it to an Excel table (select, INSERT, TABLE) then any formulas you add will automatically copy down for all the rows in the table. (NB you might want to 'file, save as' and convert to  .xlsx if its not in the later format already)

1. Combining date/time columns - you will need to clarify how you want them combined
2. Combining text columns - in the column to the right of the three columns (K??): = h2 & " " & I2 & " "& J2

To toggle a formula between absolute (with $ signs :- eg: $A$1) select it then press F4 and the dollar signs should disappear

If I've missed the point let me know

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Robberbaron (robr)Commented:
seems reasonable.

try turning on the Macro recorder, then doing a few manual combinations and post the resulting macro if you have troubles.
StephanieFosterAuthor Commented:
I've been working with the Macros and that is what I needed.  I don't even need the template, as far as i can tell.

thank you!
Stephanie
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.