Shift Column cells to Row cells

  • Thread starter Thread starter DV
  • Start date Start date
D

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.
 
Back
Top