I have 300,000 rows of data in about 10 spreadsheets. Column A has a query string with about 20 values. For each row, I need about 5 values extracted and put in columns on the same row (first name, last name, email address, phone number, etc). Note: these spreadsheets are Google Docs, NOT Excel so please do NOT provide me with an Excel solution and tell me to make it work in Google Docs. You must provide me with a Google Docs solution.
Below is an exerpt of the query string:
&alt_phone_country_code=1&event=submitInquiry&major_1_name=Music Production & Sound Design for Visual Media=&ppc_kywd=null&alt_phone_number=&phone_country_code=1&apartment_number=23&semester_name=Fall 2012&dob_day=24&phone_area_code=770
This should be a very very easy job for someone who knows excel well. I'd like this done in the next few hours, so the first qualified person to respond will get the job.