Transpose/Transform a table to one coloumn

[arunsparrow]

Hi,

i was looking solution for my query

i have a data as below

a b c 1
d e f 2
g h i 3
j k l 4


and i need the data as below in one column

a
b
c
1
d
e
f
2
g
h
i
3
...........

help needed in this regard either macro or formula





- Arun Sparrow

[arlu1201]

Do you need the output in the same column or column B is fine?

[arunsparrow]

any thing is fine but i need the output in one column even in a separate sheet

sorry frnd. i forget to mention that the data had more than 100 line items



Thank for revert,

Arun Sparrow

[newdoverman]

The solution to your problem can be found on this C. Pearson web site.

http://www.cpearson.com/excel/MatrixToVector.aspx

[AB33]

When you press the button on sheet1, you will get the result in new sheet.

[arunsparrow]

Hi friend,

Thanks for support

It did my work

Thanks once again