Javascript to Format Google Spreadsheet Data

  • Status Completed
  • Budget $45 USD
  • Total Bids 1

Project Description


See the three tabs of the spreadsheet linked here: [url removed, login to view]

Tab 1 ("Raw Data") has a lot of messy and poorly formatted data. I need the data in this tab to pass through a scripted filter as described in tab 2 ("Filter Actions (for developer's reference"). See the notations and comments on tab 2, and message me if you have any questions.

The result should be what is shown on tab 3 ("Formatted Result").

Data on tab 1 will change monthly, but the column headers will always stay the same. Likewise, the columns, formatting, etc. on tab 3 should stay constant.

I need this script to run on tab 1 on a manual trigger.

Tab 2 should be removed once the developer has finished writing the script. I will not be using it.

Let me know if you have any questions.

Get free quotes for a project like this

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online