+ Reply to Thread
Results 1 to 2 of 2

Transform a standardized output into structured format for Pivot table

  1. #1
    Forum Contributor
    Join Date
    09-29-2011
    Location
    Cape Town
    MS-Off Ver
    Excel 2010
    Posts
    107

    Transform a standardized output into structured format for Pivot table

    Hi,

    I receive a standard output when I export some data from an accounting software package into Excel.

    My aim is to transform this into a structured output so that I can pivot the data and create reports.

    I've attached an Excel workbook. "Sheet1" is an example of the output from exporting from the accounting package, and the tab "Consolidated" takes the first two invoices as an example and I've consolidates them in my required format. I would want to do this for all the entries in 'Sheet1"

    Things to note:
    Every "Item Code" is followed by the "Item Description"
    Every time the word "Customer ...." appears in column A we are referring to a new invoice. The invoice number is also in Column A (Total Invoice...") but right at the end of the list of Item Codes" and "Item Descriptions"
    The relevant date for the invoice in in column B on the same row as the invoice number (Total Invoice...")

    I've managed to find snippets of code to search for certain word's such as "Customer" etc. but I'm battling to make it dynamic in the sense that the number of items per invoice changes depending on the invoice.

    Would really appreciate some help.

    Thanks a million!
    Attached Files Attached Files

  2. #2
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    7,468

    Re: Transform a standardized output into structured format for Pivot table

    Welcome to the Forum, unfortunately:

    This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.
    http://www.excelforum.com/excel-prog...vot-table.html

    Thread Closed.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. How to do this output from pivot table?
    By ccastell88 in forum Excel General
    Replies: 1
    Last Post: 01-07-2016, 03:58 AM
  2. [SOLVED] Multiple Name Formats in one Column Need to be Standardized to one Format
    By mo4391 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-02-2015, 04:35 PM
  3. TextBox Output Format not Same as my Table
    By oskar44 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-19-2015, 03:57 PM
  4. Structured references for Pivot Table?
    By Cam in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-15-2015, 01:33 AM
  5. [SOLVED] Transform semi-structured bloomberg data into pivottable table
    By jasonleewkd in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-21-2013, 08:10 AM
  6. Pivot table "structured selection" issue
    By blackworx in forum Excel General
    Replies: 0
    Last Post: 11-22-2011, 08:33 AM
  7. pivot table output
    By stevekirk in forum Excel General
    Replies: 0
    Last Post: 09-15-2006, 12:47 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1