Hi - I have a pivot table that contains income statement information. Since pivot tables will not allow for insert of a row with a a formula I want to pull data from the pivot table into a new worksheet to obtain the format I need. Below is format of my pivot table. I have tried to use the get pivot data formula, but if the data changes from month to month (ex. new accounts added or deleted) I can not get the format to remain consistent. I have tried to use a lookup formula based on account name, but sometimes accounts have the same name for different accounts, so it pulls in the first line of information that matches.
If anyone has any ideas or can point me in the right direction that would be great!
Account Account Name Company 1 Company 2 Company 3
1010-00 Checking - Acct1 100
Checking - Acct2 150
Checking - Acct3 200
1010-01 Checking - Acct1 200
Checking - Acct2 250
Checking - Acct3 300