VBA Code Required to Get Data Which is In Coloums Into Rows

[stublair]

Dear All,

I could really really do with some code which would allow me to get m
data from rows into columns by this i mean i have my data in the form

id_no picture_of
1 cat
1 dog
1 horse

and i would like in

id_no picture1 picture2
picture3
1 cat dog
horse

does anyone have the code for this - if so please i would be extremel
extremely grateful.

st

 

[RB Smissaert]

Try this:

Sub test()

Range(Cells(1), Cells(4, 2)).Copy
Cells(4).PasteSpecial Paste:=xlPasteAll, _
Operation:=xlNone, _
SkipBlanks:=False, _
Transpose:=True
Application.CutCopyMode = False

End Sub


RBS

 

[Bob Phillips]

Sub test()
Range("C1:K1") = Application.Transpose(Range("A1:A10"))
End Sub


--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)