Layout of table

[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

I would greatly appreciate someones help. Thanks a bunch!
Chris P.

 

[BrianB]

Cannot see what the relationship is.

I suggest you either create table 2 to the right of table 1 usin
formulas to translate data or use Edit/Replace