I think what you are describing is this:

When you select your pivot table, two new ribbon options appear: Options
and Design. Go to the Design ribbon and click the Report Layout button. It
sounds like you are in compact form where what you are looking for is tabular
form.

"Dinesh" wrote:

Hi,

When I create a Pivot table in Excel 2007, when I drag more than one field
from data to €œRow Labels€�, all Fields are stacked up in the same Column,
instead of spreading out to separate columns. This was not the case in the
previous version of Excel. Please help me to get around this problem.

Thanks,
Dinesh