Combining Rows

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Would like to combine rows of data in the following format, everytime a field
named P.O changes. In this example, rows below 999-5U0455 would be together
on the same row as 999-5U0455 and rows below 999-5U2570 would be together on
the same row with 999-5U2570. Any help would be appreciated.
P.O
AMMS.ALDXXXXXX 999-5U0455 Paid (Partial Receipt) - Amended JUN 07,
2005
KIMBERLY CLARK HEALTHCARE DIV 1-800-742-1996

JUN 17, 2005 2 1 1

66.24 SHIP

PURCHASE CARD SUBTOTAL: 66.24



AMMS.ALDXXXXXX 999-5U2570 Ordered (No Fiscal Action Required JUN 22,
2005
OSI 800-777-4674

JUL 02, 2005 1 1 1

0.00 DISPUTED CHARGE NOT MY PO 999-U58159

PURCHASE CARD SUBTOTAL: 66.24
 
Based on your post I can not tell where a record ends or a field begins. You
indicated one field name "PO" but no others or where they start.
What are your fields?
 
With Fields: Row begins with SVC and ends with ORDER TOTAL.

GMD said:
Would like to combine rows of data in the following format, everytime a field
named P.O changes. In this example, rows below 999-5U0455 would be together
on the same row as 999-5U0455 and rows below 999-5U2570 would be together on
the same row with 999-5U2570. Any help would be appreciated.
SVC P.O STATUS DATE
AMMS.ALDXXXXXX 999-5U0455 Paid (Partial Receipt) - Amended JUN 07,
2005
Click to expand...
VENDOR PHONE
 
I typed the fields above the data, e.g., Field SVC, data is AMMS.ALDXXXXXX;
Field P.O, data is 999-5U0455; Field STATUS, data is Paid (Partial Receipt)-
Amended; Field DATE, data is JUN 07,2005, etc.,

Thanks for any help.
 
That is only three fields but you listed other data in earlier post. I might
be a little slow on this so litst the fields/data like this.
PO -- 999-5U0455
STATUS -- Paid (Partial Receipt)- Amended
DATE -- JUN 07,2005
VENDOR --KIMBERLY CLARK HEALTHCARE DIV
PHONE -- 1-800-742-1996
DATESHIP -- JUN 17, 2005
QTY -- 2
RC -- 1
OP -- 1
AMT -- 66.24
STAT -- SHIP
ORDER TOTAL --

Then tell me where the data splits to form a new record/row.
 
Second row would start with AMMS.ALDXXXXXX 999-5U2570 and end with PURCHASE
CARD SUBTOTAL: 66.24
 
I had thought that your data was spread over multiple rows/records and you
wanted to combine them into a single row/record. Now it sounds like you
want to combine multiple records into a single row/record.
Did I go wrong again in my thinking?

You gave me two rows of data. If my thinking is wrong then maybe you need
to give me five or six row/records of data. Then tell me where the new
break/separation of first - second row/record would be.
 
KARL DEWEY said:
I had thought that your data was spread over multiple rows/records and you
wanted to combine them into a single row/record. Now it sounds like you
want to combine multiple records into a single row/record.
Did I go wrong again in my thinking?

You gave me two rows of data. If my thinking is wrong then maybe you need
to give me five or six row/records of data. Then tell me where the new
break/separation of first - second row/record would be.
Click to expand...
 
Record #1
AMMS.ALDXXXXXX 999-5U0455 Paid (Partial Receipt) - Amended JUN 07,
2005
KIMBERLY CLARK HEALTHCARE DIV 1-800-742-1996

JUN 17, 2005 2 1 1

66.24 SHIP

PURCHASE CARD SUBTOTAL: 66.24


Record #2
AMMS.ALDXXXXXX 999-5U2570 Ordered (No Fiscal Action Required JUN 22,
2005
OSI 800-777-4674

JUL 02, 2005 1 1 1

0.00 DISPUTED CHARGE NOT MY PO 999-U58159

PURCHASE CARD SUBTOTAL: 66.24
 
When you put the second row data in the same row as the first row what are
you going to use for the field names?
 
This is how I want the data to appear in a table:
ROW 1 FIELD SVC - AMMS.ALDXXXXXX
ROW 1 FIELD PO - 999-5U0455
ROW 1 FIELD STATUS - Paid (Partial Receipt) - Amended
ROW 1 FIELD DATE - JUN 07, 2005
ROW 1 FIELD VENDOR - KIMBERLY CLARK HEALTHCARE DIV
ROW 1 FIELD PHONE - 1-800-742-1996
ROW 1 FIELD DATESHIP - JUN 17, 2005
ROW 1 FIELD QTY - 2
ROW 1 FIELD RC - 1
ROW 1 FIELD OP - 1
ROW 1 FIELD AMT - 66.24
ROW 1 FIELD STAT - SHIP
ROW 1 FIELD ORDER TOTAL - PURCHASE CARD SUBTOTAL: 66.24

ROW 2 FIELD SVC - AMMS.ALDXXXXXX
ROW 2 FIELD PO - 999-5U2570
ROW 2 FIELD STATUS - Ordered (No Fiscal Action Required
ROW 2 FIELD DATE - JUN 22, 2005
ROW 2 FIELD VENDOR - OSI
ROW 2 FIELD PHONE - 800-777-4674
ROW 2 FIELD DATESHIP - JUL 02, 2005
ROW 2 FIELD QTY - 1
ROW 2 FIELD RC - 1
ROW 2 FIELD OP - 1
ROW 2 FIELD AMT - 0.00
ROW 2 FIELD STAT - DISPUTED CHARGE NOT MY PO 999-U58159
ROW 2 FIELD ORDER TOTAL - PURCHASE CARD SUBTOTAL: 66.24
 
Ok we try again. Is all of your data in a single field for each row? If
yes, then I assume that you want it split into the separate field you show.
If this is correct then tell me the name of the current table and the field
name.

If the above assumption is not true then please try to explain it again.
 
Ok, I just need to figure out how to parse the data. The data you post a
7:18 today and that posted on 16th at 10:03 does not have the same number of
spaces.

I need an exact pasting of your data. It will be helpful to have 5-6 records.
 
KARL DEWEY said:
Ok, I just need to figure out how to parse the data. The data you post a
7:18 today and that posted on 16th at 10:03 does not have the same number of
spaces.

I need an exact pasting of your data. It will be helpful to have 5-6 records.
Click to expand...
 
Back
Top