The format that another application spits out is one that I would like to
make user friendly. Here is an example of what I am looking at:
WELL: 5122110000 3096971.9998
PICK: GRETA
**Each line of data is in one cell

In my normal file I have anywhere between 400 to 2000 rows of data. I would
like something that will take the lines that have "PICK:" and place all that
information on the row above it and paste that line of data after the end of
the data in the row "WELL:"

So what this line would look like would be:
WELL: 5122110000 3096971.9998 PICK: GRETA

When it puts the line with "PICK:" it would be great if there was a space
between the last value in the line with the "WELL:" and the P in "PICK:"

Thanks for the help