I don't know if this is what you are asking about but if your data
looks like this:

Name Data Value
Will Age 30
Will Weight 170
Joe Age 25
Joe Weight 159

Then when you create a pivot table of that data it will look like this:
Name Age Weight
Will 30 170
Joe 25 159

which is the example you posted before.

Cheers,
Jason Lepack

BillyBob wrote:
Does anyone know how to put to data variable side by side? Like Name in row
and age and weight in the data field, where they would show in the Pivot
table ...