In column A I have the following :
Game 1
f
d
r
y
g
t
e
w
h
j
Game 2
f
h
y
u
i
g
f
r
Game 3
d
e
f
g
y
o
p
l
k
Game 4
d
s
w
q
I would like to extract to column B everything from Game 1 down to the cell above Game 2 and into Column C everything from Game 2 down to the cell above Game 3, and into Column D everything from Game 3 down to the cell above Game 4 etc etc etc
Any ideas ?
Chris
Game 1
f
d
r
y
g
t
e
w
h
j
Game 2
f
h
y
u
i
g
f
r
Game 3
d
e
f
g
y
o
p
l
k
Game 4
d
s
w
q
I would like to extract to column B everything from Game 1 down to the cell above Game 2 and into Column C everything from Game 2 down to the cell above Game 3, and into Column D everything from Game 3 down to the cell above Game 4 etc etc etc
Any ideas ?
Chris