Manipulation of excel spreadsheet

- or -

Post a project like this

Ends in (days)

17

Fixed Price

£50(approx. $66)

Posted: 2 months ago
Proposals: 18
Remote
#4422394
Awarded

Muhammad T.

Muhammad S.

Sameer G.

Thomas B.

Rakibul I.

+ have already sent a proposal.

Description

Experience Level: Entry

We have a supplier spreadsheet that gives prices for calling a specific country / network as in the below example ( the | indicates the column delimiters )
|Destination | Price | dial codes |
|Jordan - Mobile | 0.2634 | 96275, 96277, 96278, 96279 |

We need the data manipulated so that there are multiple lines for each dialing code as below
|Destination | Price | dial codes |
|Jordan - Mobile | 0.2634 | 96275 |
|Jordan - Mobile | 0.2634 | 96277 |
|Jordan - Mobile | 0.2634 | 96278 |
|Jordan - Mobile | 0.2634 | 96279 |

An example of the spreadsheet to be manipulated is attached

New Proposal

Login to your account and send a proposal now to get this project.

Clarification Board Ask a Question

There are no clarification messages.