Merging rows - previous / peek ?

[shane_spencer]

I've got some data that I've cleansed but at the point where I need to merge two rows or in Excel terms move some values up a row.

i.e. For those 5 fields where TRANS_REF_LINE is 001 they want to be merge with the above row.

If it helps the TRANS_REF_DOC field is unique. What's the easiest way of doing that? I've got an inkling that it may be using Previous or Peek but unsure of the best way.

[pnn44794]

Hello Shane:

Did you ever figure out how to do this?  I have a very similar need.  Thanks in advance.