Reverse Pivot Table - Convert budget rows with 12 month columns to 12 rows - 1 per month

[MikeKi]

I have a typical budget sheet with a few hundred rows of line items and need to import it into our accounting system. Below is a simplified example, but demonstrates the problem.

For each budget line the columns look like:

Please Login or Register  to view this content.

I would like to easily convert that to something that looks like:

Please Login or Register  to view this content.

The period contains the first day of the month in question. The result is that each original budget line would now be 12 rows. It's kind of like a reverse pivot table.

I'm hoping for a solution that doesn't involve VBA...

Thanks in advance.

[Pepe Le Mokko]

Perhaps this link will help

[MikeKi]

Thank you.

I knew I wasn't the first person to want to do this.

Mike