Peruttu

Convert and merge a small text file into a spreadsheets

We have a 440 row by 15 column text file that needs to have some columns merged and outputted into Excel or Macintosh Numbers format. The current 15 columns need to be merged in 7 columns.

1) Date, 2) Security Description 3) CUSIP # 4)Transaction Description 5) Quantity 6) Price 7) Amount

The items listed in the "Amount" column as "Bought" in the "Transaction Description" column need to be a positive number. In the same column the items listed as "Sold" need to be a negative number in order to sum the column. I will send a pdf scanned from an original statement so that the format needed can be seen.

Please advise. Thank you.

Taidot: tiedonsyöttö, Excel

Näytä lisää: price file, text file, spreadsheets, data to text file, convert order, convert excel spreadsheets numbers, text row, column text, convert scanned pdf excel, excel text column, convert statement file, excel text columns, merged, spreadsheets needed, excel row convert text file, pdf file convert excel, merge data excel pdf, convert text file excel file, small excel, statement format excel, text convert excel, convert pdf file excel format, small format, convert columns text excel, merge excel pdf

Tietoa työnantajasta:
( 0 arvostelua ) Mumbai, India

Projektin tunnus: #1701450

8 freelanceria on tarjonnut keskimäärin 47 $ tähän työhön

vgrichards

Very Good at Excel 2003-2010 and Excel VBA Macros. Please allow me to do it. Will ensure everything is as per your requirement.

30 $ USD 1 päivässä
(26 arvostelua)
4.1
khiemdmse60773

I can use computer programming in excel to get this work done. I will satisfy you with this project.

30 $ USD 2 päivässä
(2 arvostelua)
1.6
adelapocriste

I can do this, I have many years experience working in Excel.

120 $ USD 1 päivässä
(0 arvostelua)
0.0
Faisal1000

am new here on this site but i have alot of experience only need one chance to prove my abilities.

30 $ USD 2 päivässä
(0 arvostelua)
0.0
Fredrick422

I have read and understood the requirements in your project give me the job and I will not disappoint you

50 $ USD 2 päivässä
(0 arvostelua)
0.0
dridjic

HI!!This project presents an initial challenge for me. From my experience, which can be seen in my profile, I possess skills of writing, data entry and processing. I believe that I can take out this job with very high Lisää

40 $ USD 6 päivässä
(0 arvostelua)
0.0
Bobuh

I manipulate text files into Excel on a daily basis. Would be happy to take this on for you.

45 $ USD 2 päivässä
(0 arvostelua)
0.0
darachellison

Advanced excel user, data conversion relatively simple and can complete within 3 hours.

30 $ USD 1 päivässä
(0 arvostelua)
0.0