PATools Excel Data Restructuring

Many organisations find that over time they build up data in spreadsheets in a certain format, but now have a requirement to reorganise the same data in a new format. Unfortunately this often means a large amount of printing, keying or re-keying, and/or time-consuming and tedious copying and pasting.

Not any more!

PATools has helped a number of organisations to collect, index, and re-structure data, either from multiple spreadsheet files into one, or from multiple sheets into one. This has sometimes meant re-organising, removing duplicates, and further indexing the same data.

Examples include:

  • Historical order information needs collating from some 150 spreadsheets into one new database
  • Invoice numbers, dates, amounts, and customer names and addresses need summarising from nearly 2500 Excel files into one Access database, and the final data to be checked for duplicate invoice numbers
  • Staff work data kept in a tabular calendar format (ie one day in each cell, months in rows, days in columns) needs to be put into one database

Whatever your requirement, you may find it quicker, more accurate, and CHEAPER to get PATools to do it.

Our web service works like this:

  • Initial enquiry via Contact Us form - please supply a brief summary of your requirement
  • We respond
  • You send sample data, or examples, or whatever is appropriate from our discussions
  • We quote a price and date for delivery, plus an explanation and perhaps small sample of the final result to ensure we both know what is to be done
  • You send full data (by email, or CD/DVD, as appropriate)
  • We complete the project, and send a sample of the result
  • You pay on-line by Paypal or Credit Card, normally 80% of the agreed price
  • We send the full final result
  • You pay the balance

Our prices and delivery times are guaranteed - no nasty surprises.

We, of course, treat your data as completely confidential and it is well protected by firewalls, anti-virus etc. We remove your data upon completion of the transaction.

Please feel free to contact us to discuss.