Excel File

[yummy7]

I have excel sheet and I want to change its view. To make rows as columns.Like
Sr. 1 2
name Keyboard Scanner
type w/y mn
model 0021 3256
Into
Sr. name Type model
1 Keyboard w/y 0021
2 Scanner mn 3256
Any suggestion is most appreciated.

 

[Lilliabeth]

Select and Copy the range
Select a cell out of the way and choose
Edit > Paste Special
Tick the Transpose checkbox
Click OK

Lilliabeth
-Why use a big word when a diminutive one will do?-

 

[yummy7]

Thankyou very much.It works.