Hello All,

I have some data that looks like this...

Field 1 Field 2
VendorName Yokogawa Electric
ModelName EJA100A
Revision R2.00
ManufacturerID 5850435
DeviceType 3
DeviceRevision 2
DdRevision 1
PdTag FT-3121B
NodeAddress 0xf7
DeviceClass BASIC
DeviceID 5945430003J0008436
DeviceNo 1

VendorName Yokogawa Electric
ModelName EJA100A
Revision R2.00
ManufacturerID 5850435
DeviceType 3
DeviceRevision 2
DdRevision 1
PdTag FT-3152B
NodeAddress 0xf6
DeviceClass BASIC
DeviceID 5945430003J0008926
DeviceNo 2

VendorName Yokogawa Electric
ModelName EJA100A
Revision R2.00
ManufacturerID 5850435
DeviceType 3
DeviceRevision 2
DdRevision 1
PdTag PT-3011
NodeAddress 0xf5
DeviceClass BASIC
DeviceID 5945430003J0009091
DeviceNo 3



As you can see the data in field 1 is repeated so i want to have that as a
row heading and field 2 as the data. I have tried a pivot table but can only
get get data summaries such as count , min , max etc.

Is there a way to create a piviot table using the data itself rather than
summaries.?

I have manaegd to do it in access but cant get it to work in excel.

Any help appreciated