How to make Excel automatically populate all data from specific column into a range

Hi.

I will try my best to explain my problem.

I have data in the following format:
Column A - contains the expenditure type
Column B - contains the expenditure amount for Department A
Column C - contains the expenditure amount for Department B
Column D - contains the expenditure amount for Department C
The rows for the above table could vary from month to month.


How could Excel populate the pivottable data above into the following format in another worksheet:

1. Data from column A to be populated into Column A starting from Row 1
2. Data from column B to be populated into Column B starting from Row 1
3. Data from column A to be populated again into Column A starting from the Row immediately following the last populated Row in step (1) above
4. Data from column C to be populated again into Column B starting from the Row immediately following the last populated Row in step (2) above
5. Data from column A to be populated again into Column A starting from the Row immediately following the last populated Row in step (3) above
6. 4. Data from column D to be populated again into Column B starting from the Row immediately following the last populated Row in step (4) above

Thanks.

Hi,

Anyone?

Thanks.

Hi.

I have attached a workbook showing the before and desired after results. Anyone?

Thanks.