Hello!

I've been working with ledgers to analyze companies financials in detail mostly using pivot tables and charts.

I usually get the data in a format that has the account name and number as a title on top and then each entry for this account under the title. In order to get my pivots working I need to copy the account name and number to each row until the next title.

Here is a picture to help understand what I mean:
Makrokyssäri.png

So is there a formula or a macro that could help me avoid doing the copying manually?

Thank you in advance for your help!