Conversion of excel file data format
$30-100 USD
Paid on delivery
Input file in spreadsheet format has the following features:
Column A: Name
Column B: numbers delimited with column or comma or showing a range using hyphen.
other columns - random data.
Output file must have format:
Column A: Name
Column B: one number per line
other columns - random data.
Task is to create a macros (preferred) or external application that would convert spreadsheet in requested format: one number per line.
## Deliverables
Example:
input data
<col width="248" style="width: 186pt;" /> <col width="506" style="width: 380pt;" />
| Argentina Corredores | 54221; 54223; 54230; 54232; 54291; 54299; 54342; 54348; 54353; 54358; 54381; 54387 |
output data:
| Argentina Corredores 54221 | |
| | |
| Argentina Corredores 54223
Argentina Corredores 54230 | |
and so forth.
Same rule with comma as delimiter.
If range is shown: 74-80
than 7 lines are created.
In put data can also be mixed:
ColumnA Column B
<col width="109" style="width: 82pt;" /> <col width="210" style="width: 158pt;" />
| 374 | 93-94, 77, 98 |
resulting output should show:
37493
37494
37477
37498
with other data dulicated to each new line.
| |
* * *This broadcast message was sent to all bidders on Tuesday Jun 9, 2009 11:14:14 AM:
The amount of data per converted file varies from few lines to several thousand lines. Generally it should not exceed Excel limit of 56K records.
Project ID: #3930839