Making field values appear in every cell

I have a question: is it possible to make the field values appear in every cell, instead of just the first row for that particular level? For example, instead of:

Quarter Amount
2004/2 $36.52
$95.24
$57.25
$10.98

I would like to see:

Quarter Amount
2004/2 $36.52
2004/2 $95.24
2004/2 $57.25
2004/2 $10.98

Basically, I'm wanting to use a Pivot Table as a way to create another table. I know this can be done in Access, but I'd rather do it in Excel if possible. Please help!

Thanks,
Eric

You could copy the cell with "2004/2", then select the entire range you want it to appear in and paste. It will paste it into every cell in the selected range. If you want it to automatically appear in the left cell when you enter more data in the right cell, I don't know how to do that.
Good luck.

"Eric Stephens" wrote:

I have a question: is it possible to make the field values appear in every cell, instead of just the first row for that particular level? For example, instead of:

Quarter Amount
2004/2 $36.52
$95.24
$57.25
$10.98

I would like to see:

Quarter Amount
2004/2 $36.52
2004/2 $95.24
2004/2 $57.25
2004/2 $10.98

Basically, I'm wanting to use a Pivot Table as a way to create another table. I know this can be done in Access, but I'd rather do it in Excel if possible. Please help!

Thanks,
Eric