move data from rows to columns

D

DME

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to move data in Column A into seperate columns / rows 1
move data from columns to rows 3
How to move data from rows to columns 6
VBA code for moving data from even rows to columns after data in oddrows 4
Transfer data from Excel col. A to columns B-E in the same sheet 3
Excel Macro to transpose addresses from rows to columns 3
Need help copying data from one column to specific columns 0
Help in code Steve G wrote to move data from 4 columns to 21 columns 8

Top