|
|
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 |
|
There is no answer at this time. |
|
There are no comments at this time. |
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 Home - Answers FAQ - Terms of Service - Privacy Policy |