Formatting Excel

[Chris P.]

I have a table in excel, all of the information in this
table is linked to AutoCAD. I have added an example below:

Example 1
NO. NAME BOTTOM BOTTOM TOP TOP
MAT FIN MAT FIN
101 CORRIDOR PLASTIC SMOOTH RUBBER SMOOTH
102 CORRIDOR PLASTIC SMOOTH RUBBER SMOOTH


I am trying to get Example 1 to look like Example 2
without having to re-enter everything. It is the same
info. but a different layout. I tried a Pivot Table but
was not successful. Does anyone have any ideas?

Example 2
NO. NAME BOTTOM TOP
101 CORRIDOR MAT Paint Rubber
FIN Textured Smooth
102 CORRIDOR MAT Paint Rubber
FIN Textured Smooth