One easy formulas play to tinker with ..
If the source data as posted is in cols A across within the 1st 3 rows,
with the top left cell in A1
Place this in any startcell below the source data,
say in B5:
=OFFSET(A$1,MOD(ROWS($1:1)-1,3),INT((ROWS($1:1)-1)/3))
then just copy B5 down as far as required to extract it as desired
Adapt the anchor (the "A$1") and the number of rows (the "3") to suit
Success? Celebrate it, hit the YES below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
"Anex" wrote:
I have a large data like this in an excel sheet
A D G
B E H
C F
I want to change in it to one column like this
A
B
C
D
E
F
G
H
Any function or formula please?