With 1.7 million freelancers, we'll match you with the perfect talent.
The client has made the following changes to the job.
Client prefers freelancers from:
You are still able to submit a proposal for this job.
The client prefers freelancers from
a different location.
I need to consolidate the tables from the following website:
There are two drop-down boxes for choosing the year and month. After this selection there are several tables for each selected month/year.
I would like to have all of them in one single table/database in Excel, Access or CSV format (depending on the number of lines).
The final outcome shall be two tables:
- One from 2005/Setembro (2005/September) to 2010/Março (2010/March) with the following columns: "year", "month", "Número do instrumento contratual", "Nome da contratada", "Objeto", "Valor da R$"
- And the other from 2010/Abril (2010/April) to 2011/Junho (2010/June) with the following columns: "year", "month", "Nº Contrato (Pedido)", "Item", "Descrição do Material", "Nome da contratada", "CNPJ", "CPF", "Modalidade de licitação", "Data do Documento", "Moeda do pedido", "Valor PC", "Quantidade"
The reason for the split is that the table shown...
Sign in or Register to see more