vba for rows as columns

[simma]

Hello,
I have a worksheet in excel with data like this

ln id name
15 1 jack
16 2 john

i need data in worksheet 2 as

ln 15 16
id 1 2
name jack john

Can anyone suggest a way for this

Thanks

 

[xlbo]

Edit>Copy
Edit>PasteSpecial Choose "Values" and tick "Transpose"

If you need the code, just record yourself doing it manually

Rgds, Geoff

"Three things are certain: Death, taxes and lost data. Guess which has occurred"

Please read FAQ222-2244 before you ask a question

 

[simma]

Thanks