Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
move data from rows to columns
Is there a way to combine rows of data where the company, address, name, and
other columns are the same with a product description, product code and qty that contains different data. Some companies have numerous entries for each product ordered, other companies may only have one row. THe size of the spead sheet also varies. DAGRT PROGRAM DESCRIPTION ECP 10 DIG CORP COMPANY NAME ADD1 STATE_ ZIP FIRST_NAME LAST_NAME ITEM # ITEM DESCRIPTION ORDER UOM SHIPPED QTY 1410631 ALLIED BUSINESS 74121594 350081 W G LEFFELMAN & SONS INC 340 N METCALF AVE IL 61310-1119 Doug O'Rourke BLW2 W-2 BLANK FACE & BACK LASER 1=1PK EA 11 1410433 AMERINET 72004581 334523 SPECIALIZED MEDICAL MGMT 4900 BARRANCA PKWY STE 103 CA 92604-8603 Melinda S LMISCRECST 1099 MISC ST COPY LASER 1=1PK PK 2 1410433 AMERINET 72004581 334523 SPECIALIZED MEDICAL MGMT 4900 BARRANCA PKWY STE 103 CA 92604-8603 Melinda S 7956E 7956E/DW ENV FOR 1099 R,MISC,DIV,B/MW396 EA 1400 1410433 AMERINET 72004581 334523 SPECIALIZED MEDICAL MGMT 4900 BARRANCA PKWY STE 103 CA 92604-8603 Melinda S L1096NC FREE LASER 1096 TRANSMITTAL 1EA EA 4 1410433 AMERINET 72004581 334523 SPECIALIZED MEDICAL MGMT 4900 BARRANCA PKWY STE 103 CA 92604-8603 Melinda S LMISCFED 1099 MISC COPY A LASER 1=1PK PK 2 1410433 AMERINET 72004581 334523 SPECIALIZED MEDICAL MGMT 4900 BARRANCA PKWY STE 103 CA 92604-8603 Melinda S LMISCREC 1099 MISC COPY B LASER 1=1PK PK 2 1410433 AMERINET 72004581 334523 SPECIALIZED MEDICAL MGMT 4900 BARRANCA PKWY STE 103 CA 92604-8603 Melinda S LRFEDA 1099 R COPY A LASER 1=1 PK PK 1 1410433 AMERINET 72004581 334523 SPECIALIZED MEDICAL MGMT 4900 BARRANCA PKWY STE 103 CA 92604-8603 Melinda S LRPAY 1099 R COPY 1/D LASER 1= 1 PK PK 1 1410433 AMERINET 72004581 334523 SPECIALIZED MEDICAL MGMT 4900 BARRANCA PKWY STE 103 CA 92604-8603 Melinda S LRREC2 1099 R COPY 2 LASER 1=1 PK PK 1 1410433 AMERINET 72004581 334523 SPECIALIZED MEDICAL MGMT 4900 BARRANCA PKWY STE 103 CA 92604-8603 Melinda S LRRECB 1099 R COPY B LASER 1=1PK PK 1 1410433 AMERINET 72004581 334523 SPECIALIZED MEDICAL MGMT 4900 BARRANCA PKWY STE 103 CA 92604-8603 Melinda S LRRECC 1099 R COPY C LASER 1=1 PK PK 1 1410433 AMERINET 72004581 334523 SPECIALIZED MEDICAL MGMT 4900 BARRANCA PKWY STE 103 CA 92604-8603 Melinda S LMISCPAY 1099 MISC COPY C LASER 1=1PK PK 2 1410634 AUTO/TRUCK PRIDE 71645177 261678 REPUBLIC DIESEL 305 E COLLEGE ST KY 40203-2395 Priscilla Fields TT3B W-2 EMPLOYEE SET 3 PART NCR 2/PG EA 276 1410634 AUTO/TRUCK PRIDE 71645177 261678 REPUBLIC DIESEL 305 E COLLEGE ST KY 40203-2395 Priscilla Fields TT4A W-2 EMPLOYER SET 4 PART NCR 2/PG EA 276 1410634 AUTO/TRUCK PRIDE 74139630 499947 PRECISION BRAKE & WHEEL 15 E BELLEVIEW AVE CA 93257-2441 Joy Kanthack LW24 W-2 4 PART KIT LASER 50/PK EA 1 The above is a sample of the data in question. I need each company to have one row that contains all the items ordered. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
move data from columns to rows | Excel Worksheet Functions | |||
How to move data from rows to columns | Excel Discussion (Misc queries) | |||
how do i automatically move data from rows to columns? | Excel Discussion (Misc queries) | |||
how do I move data in prexisting rows to columns? | Excel Worksheet Functions | |||
Move Data from rows to columns... | Excel Worksheet Functions |