Message data in Excel spreadsheet

  • Posted:
  • Proposals: 11
  • Remote
  • #590725
  • Awarded
Simon B.Mahtab H.Paul S.James H.Sandra T. + 6 others have already sent a proposal.
  • 0

Description

Experience Level: Intermediate
Description of excel work: I need data in a .xls spreadsheet transformed from:

a
b
c
d
e

to

a,b,c,d,e
Extra notes: I have a spreadsheet, sample attached, which gives spreads approximately 200 sets of contact details over 12 rows per contact.

the 1st row gives the contact's name across cells A-C,
the 3rd row gives the contact's day-time phone-number in cell C
the 4th row gives the contact's evening phone-number in cell C
the 5th row gives the contact's mobile phone number in cell C
the 6th row gives the contact's email address in cell C

I need this transformed into a spreadsheet with the data presented as:

name, day-time phone-number, evening phone-number, mobile phone-number, email address

New Proposal

Create an account now and send a proposal now to get this project.

Sign up

Clarification Board Ask a Question

    There are no clarification messages.