Repeating fields in pivot table source

Hi there!

I have a problem with my pivot table:

Lets assume I have the following source for my pivot table:

Month	Type	Value	Description	Category 1	Category 2
January	Variable expenses	1,00	Test description	Some category	So
		2,00	Another test description	Some category	Some other category
		3,00	Test description	Some category	Some other category
	Revenue	1000,00	Some revenue	Rvenue cat	Other cat
		500,00	Some other revenue	Rvenue cat	Other cat
February	Variable expenses	4,00	Test description	Some category	So
		5,00	Another test description	Some category	Some other category
		6,00	Test description	Some category	Some other category

[...]
and so on. If I now try to make a pivot table out of this, excel just evaluate the first row for January, February and so on but does not automatically recognize, that all the other rows (up to February) are also part of January. Its just shown as "empty". The same thing for my "types". Yes - I could now just copy the value of January down till it reaches February and the same for types too but that would make the source extremely confusing and bad formatted. Would look like:

Month	Type	Value	Description	Category 1	Category 2
January	Variable expenses	1,00	Test description	Some category	So
January	Variable expenses	2,00	Another test description	Some category	Some other category
January	Variable expenses	3,00	Test description	Some category	Some other category
January	Revenue	1000,00	Some revenue	Rvenue cat	Other cat
January	Revenue	500,00	Some other revenue	Rvenue cat	Other cat
February	Variable expenses	4,00	Test description	Some category	So
February	Variable expenses	5,00	Another test description	Some category	Some other category
February	Variable expenses	6,00	Test description	Some category	Some other category

That would work but (as you can see) is not really a solution if you want to keep the data clear.

Is there an option in pivot tables to say excel: please reuse the value you found if there is an empty cell or somethin like this?

Thanks for the answers!