Shift Column cells to Row cells

[DV]

Hello ALL,
I have data in cell A, which correponds to data in Column
B, C and D.
What I want to do is, have multiple lines of data in cell
A, each individually corresponding to data in Cells B, C
and D.
I mean, I have
cell A cell B cell C cell D
123 abc def ghi

I want
cell A cell B
123 abc
123 def
123 ghi

What is the faster way to do it.
Please help.
Thanks in advance,
DV.

 

[Biff]

Hi DV,

Use Copy>Paste Special>Transpose

Biff