Pete,
Many thanks for your reply, yes I do understand what you say... I can
indicate the start of a new record, I do have other data against the row of
data, but this fine. In total I have 500 rows which is about 250 ish
records..

Regards - Paul


"Pete_UK" wrote in message
...
If there is no pattern, then how would you expect an Excel formula to
deduce that a particular row is the start of a new record? What other
data do you have? Can this be used to determine a new record? Is it
possible for you manually to enter a character like "Y" in appropriate
cells to indicate start of new record? (i.e. how much data do you
have?)

Pete

On Feb 6, 11:05 am, "PR" wrote:
Is there a quick way of turning text that is on multiple rows into one
row,
one problem that have with this, is that I have text say in 4-7 that I
what
all in row 4, then the next maybe row 8 & 9 into row 8, then the next
maybe
row 12-14 into row 12 and so on. They is no pattern to this...

Regards - Paul