Google Answers Logo
View Question
 
Q: parse an excel spreadsheet ( No Answer,   0 Comments )
Question  
Subject: parse an excel spreadsheet
Category: Computers > Software
Asked by: jbehrens1-ga
List Price: $10.00
Posted: 21 Aug 2006 11:53 PDT
Expires: 21 Aug 2006 17:38 PDT
Question ID: 758138
I need the following attached spreadsheet parsed. 
http://www.mytempdir.com/878200

Details follow:

The file has 3 sheets. Ignore the ?session details? sheet.

The first sheet is the ?original data?.
The second is an example of what I?d like done for the first record
(?sample fixed?)
.
What I?d like is the following:
In Column U each cell lists all of the investment rounds the company
raised. The rest of the cells in each row have other information about
the company. I would like each row of each cell in column U parsed
into 3 fields (?horizontally?) and also parsed into separate rows for
each investment round detail line (?vertically?). Remaining data about
each company can be duplicated in the newly created rows.

Please email any questions.

JB
Answer  
There is no answer at this time.

Comments  
There are no comments at this time.

Important Disclaimer: Answers and comments provided on Google Answers are general information, and are not intended to substitute for informed professional medical, psychiatric, psychological, tax, legal, investment, accounting, or other professional advice. Google does not endorse, and expressly disclaims liability for any product, manufacturer, distributor, service or service provider mentioned or any opinion expressed in answers or comments. Please read carefully the Google Answers Terms of Service.

If you feel that you have found inappropriate content, please let us know by emailing us at answers-support@google.com with the question ID listed above. Thank you.
Search Google Answers for
Google Answers  


Google Home - Answers FAQ - Terms of Service - Privacy Policy