column merge

[b166er]

Hi members,
I have data in four columns as I presented below.Is there any method in excel thourgh which i could convert data of four columns in one column as
A
A
A
A
A
A
A
B
B
B
B
B
B
B
C
C
C
C
C
C
C
D
D
D
D
D
D
D






COL1 COL2 COL3 COL4
A B C D
A B C D
A B C D
A B C D
A B C D
A B C D
A B C D

[ben77]

Hi,

Give this a try, it assumes your list is in column A and starts at row 1:

Please Login or Register  to view this content.

Hope this helps

B

Hi members,
I have data in four columns as I presented below.Is there any method in excel thourgh which i could convert data of four columns in one column as
A
A
A
A
A
A
A
B
B
B
B
B
B
B
C
C
C
C
C
C
C
D
D
D
D
D
D
D






COL1 COL2 COL3 COL4
A B C D
A B C D
A B C D
A B C D
A B C D
A B C D
A B C D