Convert and merge a small text file into a spreadsheet

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, row spreadsheet, data to text file, convert order, text row, column text, convert scanned pdf excel, excel text column, convert statement file, excel text columns, merged, excel row convert text file, pdf file convert excel, merge data excel pdf, convert text file excel file, merge pdf spreadsheet, small excel, statement format excel, text convert excel, convert pdf file excel format, small format, convert columns text excel, merge excel pdf, convert excel text

Tietoa työnantajasta:
( 2 arvostelua ) Bedford, United States

Projektin tunnus: #1701381