Put the data in a pivot table. Place the cell anywhere in the middle of your
data and select Data - Pivot Table. When the wizard comes up you can
probably just select Finish as the default settings shoud be good enough. it
will create a new sheet with a pivot table on it. Place the Items in the left
column, the codes in the row across the top and the values in the middle...
--
HTH...

Jim Thomlinson


" wrote:

I need to change data from this format
ItemNo PCAL PCBW PCCH
PH53015 43 43 16

to this format.
Item Code Value
PH53015 PCAL 43
PH53015 PCBW 43
PH53015 PCCH 16

Can some one help me out?

Thanks