Hi. I am new into the group.
I have a new excel sheet that I create everytime I run a SQL query. I
pull information from MAS90 software.
Some of the information I'm getting is:
PO number Item #, QTY, Description 1.
This is the problem:
For every PO#, I could get up to four lines.

248020145 788904611392 RV JCP 600 PRESTIGE WGD COMF-K 1
248020145
00000000000000000020
248020145 788904611378 RV JCP 600 PRESTIGE WGD COMF-T 1
248020145
00000000000000000012
349236056 788904641382 FV JCP PRESTIGE WGD PILLOW-Q 2
349236056
00000000000000000017

How do I combine the second line (...000020) to the first one and the
fourth one to the third one?
I need to check if the PO column is the same. if it is,
then if the item # cell is emty (Column B) copy F6 to F5 and delete
the entire row.

Repeat the check for the PO # column.
Bottom line is to end up with one row of just one PO #, item #,
description, qty, and "long number"
Is there anyone who can helo me figure this out?
Thank you.
I will appreciate it enternaly.
Francisco