Hernan

If you EditCopy the pivot table and then EditPaste special...Values to a
new location

Is that what you are looking for?

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
www.nickhodge.co.uk


"HERNAN" wrote in message
...
Does anybody knows how to get the data out of the pivots table?
I meant all the data in rows again but group in the NEW format.
THANKS!!!