I have the data coming in, in the format attached to this post.
I need to compare accounts and amounts to table in another system.
As you see, this default format is not suitable for pivoting, as the data is not formatted to be used in pivot right away, there are blanks and missing column headers.
To counter this, I used this page as a base, which the data is feeded to another sheet, which is formatted in table format and empty cells filled manually, image is attached as well.
The result is, if I add brand new report into the sheet, then table is automatically updated and when I refresh pivot, the data is all there.
BUT... I want to skip the table part and reduce complexity (might be a joke
) if possible.
I would imagine this, that since source data format cannot be changed, The pivot (or other solution) would be created as a named range to take data from original source page and results me the data with the following headers: Accounts, companies and balance. All this without extra sheet of converting data to table and pivoting.
I need to compare accounts and amounts to table in another system.
As you see, this default format is not suitable for pivoting, as the data is not formatted to be used in pivot right away, there are blanks and missing column headers.
To counter this, I used this page as a base, which the data is feeded to another sheet, which is formatted in table format and empty cells filled manually, image is attached as well.
The result is, if I add brand new report into the sheet, then table is automatically updated and when I refresh pivot, the data is all there.
BUT... I want to skip the table part and reduce complexity (might be a joke
) if possible.I would imagine this, that since source data format cannot be changed, The pivot (or other solution) would be created as a named range to take data from original source page and results me the data with the following headers: Accounts, companies and balance. All this without extra sheet of converting data to table and pivoting.
