gmlopez275
New Member
I would like to re-arrange my pivot table into a more compressed state (NOT compact layout). I have a table with row/column headers. Notice in the attached workbook, there is no data in values area - for purposes of this post, I don't need the sum/count/avg/etc values, I need the actual text in the rows:
Is there any way to pull from the pivot table or source data with VBA or a formula? If there is, I can then apply the code/formula to many other workbooks with variable number of Serial and category combinations.
Using a pivot table creates a vertically long table. I need a more compressed table, such as what I have in the attached workbook. A standard PT consumes too much real estate when inserted into a Word document.
I thought about getpivotdata, vlookup, if(isblank...)... all to no avail. Seems like it should be a simple formula. I just don't know what it is. The table conveys the general structure of the data. The ideal solution will concatenate the categories when there are multiple values associated with a single Serial. Also, I would like to account for Serials of variable length (A-C, A-F, or A-Z, etc).
Is there any way to pull from the pivot table or source data with VBA or a formula? If there is, I can then apply the code/formula to many other workbooks with variable number of Serial and category combinations.
Using a pivot table creates a vertically long table. I need a more compressed table, such as what I have in the attached workbook. A standard PT consumes too much real estate when inserted into a Word document.
I thought about getpivotdata, vlookup, if(isblank...)... all to no avail. Seems like it should be a simple formula. I just don't know what it is. The table conveys the general structure of the data. The ideal solution will concatenate the categories when there are multiple values associated with a single Serial. Also, I would like to account for Serials of variable length (A-C, A-F, or A-Z, etc).