comibantion of various functions

[fflores818]

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

 

[Mike]

It can be done. But it would be easier to have the workbook to write the
code. If you want you cab send me a copy of the workbook and can code you up
something.
Just let me know.

 

[fflores818]

It can be done. But it would be easier to have the workbook to write the
code. If you want you cab send me a copy of the workbook and can code youup
something.
Just let me know.








- Show quoted text -

Hi MIke.
What e-mail should I send you the file to?
thank you for your help.
Francisco

 

[Mike]

Francisco,
Send to (e-mail address removed)
Also on another sheet or a different workbook show what you want the sheet
to look like when finished.

Thanks Mike