Hi, I have a pivottable as in the screenshot (PivotTable.JPG). How can I strip it of the pivottable formatting/layout and convert it into a pure data table with VBA (as in DesiredTable.JPG)?
I have highlighted in red in the desired (output) table the areas that require additional attention. In particular, PivotTables do not repeat field values if they are shared by several rows (e.g. we need to insert the value "A" into A3 of the desired table).
I know the desired table in this example can be typed out without VBA, but this is a simplified version of a much bigger table which will require VBA to systematically approach this (e.g. RowField1 will contain more values than just "A" and "B").
Many thanks.
Bookmarks