dbmagnus
11-18-2010, 02:18 PM
I have an Excel2010 pivot table that has three “levels” (Trans_Type, Country, Customer) in the “Row Labels” column, and one “values” column (“Transactions”). I need to put this data into a Table with 4 columns (Trans_Type, Country, Customer, Transactions).
However, when I copy and paste the data from the pivot table all three “levels” in the pivot table reside in the same table column. For example: row 1 has the 1st Trans_Type subtotal, row 2 has 1st Country subtotal, then row 3 begins the Customer detail. There are 4 Trans_Types, up to 20 countries for each Trans_Type, and up to 30 titles for each country…all buried in the same column.
So unless there’s another way to split them out (perhaps a pivot table setting) I figured I needed to come up with some VB code to identify the “breaks” for each “level”. Being a novice VB user I’m unsure of the best way to proceed.
Any suggestions or directions to point me in would be greatly appreciated. Thanks!
However, when I copy and paste the data from the pivot table all three “levels” in the pivot table reside in the same table column. For example: row 1 has the 1st Trans_Type subtotal, row 2 has 1st Country subtotal, then row 3 begins the Customer detail. There are 4 Trans_Types, up to 20 countries for each Trans_Type, and up to 30 titles for each country…all buried in the same column.
So unless there’s another way to split them out (perhaps a pivot table setting) I figured I needed to come up with some VB code to identify the “breaks” for each “level”. Being a novice VB user I’m unsure of the best way to proceed.
Any suggestions or directions to point me in would be greatly appreciated. Thanks!