CSV file through Pivot Table to Statistical information.

Hi Jay,

The second one I think is more complex.

Currently I get a CSV file of information wihich I import to a Pivot table, apply filters to get the information I need. I copy the pivot table into an ordinary worksheet. I have secondary information which I use to find look up the information I require out of the data from the pivot table. I copy and paste this into another template, match the fields and create the report.

the goal would be for the CSV information to be Inimported into a speadsheet, it matched with the current information we need the results on and the final information created. I have attached The final report with the information we use. We keep adding each months results. There are calculations rows 192 and 194 that I adjust with the addition of the new information.

The information form the CSV file is added by importing from Text, Delimited by Tab and | (not I). The Pivot Table is created selecting all the information. I then use the filters as shown. From here I use find matching the externalID with the AER numbers we wish to add.

Ideally this can all be one on importing. Flexibility required is the Recruitment Process as a filter. Some of the difficulties are the matching of the stsus. the finished table has less Status - The other status generated in the pivot table information are not relevant.

Let me know if this makes sense?

Cheers Rob

The site is telling me I have suploaded the CSV file and the Job Timing FY 2012-2013 Spreadsheet. Let me know if you dont have them. I had to split the Pivot table and Import into separate files as the whole thing was too large.

Keahlian: Excel

Lihat lebih lanjut: i need a job in recruitment, csv spreadsheet, recruitment process, Speadsheet, csv file, aer, spreadsheet csv, split file, spreadsheet copy csv, table csv, csv text file, csv table, pivot report, create pivot table csv file, tab csv delimited, text file create form data, csv data process, table filter, importing csv file, csv file template, import csv fields text, job worksheet template, adding rows, match paste data, create csv file template

Tentang Pemberi kerja:
( 26 ulasan ) Hawthorn East, Australia

ID Proyek: #6761833

Diberikan kepada:


Hired by the Employer

$15 USD / jam
(100 Ulasan)