Results 1 to 1 of 1
  1. #1
    Join Date
    Aug 2011

    Unanswered: Create multiple pivot tables from data in one column

    Thank you all for your help.

    I am trying to automate the process of creating separate pivot tables from each of the sets of data on the attached file. The issues I have are assigning the column headings (which are only in row 1) to each of the sets. The other issue is that the data for each set (i.e., the colors and the number of them) will be different each time I run the report.

    Any suggestions for the steps I need to take to automate this process as much as possible.
    Attached Files Attached Files

Posting Permissions

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