Frank: It is not clear exactly what you are looking for.

1) Are are the PO on one worksheet?
2) How do we tell where the last PO is located?
3) What do you want to do with the total Row?
4) what do you want to do witth the Spec data. do you wand to combine with
abc so it reads in one cell abc Spec1, Spec2, Spec3. or do you want to put a
1 in column A?

"Frank Situmorang" wrote:

Hello:

We have Purchase orders type in excel all the way down with the same height
( number of rows is the same), now I want to convert so many purchase orders
to be row wise in order to maniputalte data liek sorting by material
description and then we know the lowest price historically.
This is my form of P.O ( more or less). in excell

To : Supplier P.O No.
P.O Date

PO Line Description Qty U.Price Ext. Price
--------- ------------ ----- -------- ---------
1. abc 2 100 200
2. xyz 4 200 800
----------
Total 1,000.-
If there is no sppec below the description, I can do it, but it could be the
other p.o is like this:
PO Line Description Qty U.Price Ext. Price
--------- ------------ ----- -------- ---------
1. abc 2 200 400
Spec1
spec2
spec3
------------
Total 400
How can I make it the specification was typed downword and could be many
lines and some times is coutinued with the other item with only 1 spec in the
description column

It is too tough for me, please help, I appreciate your idea.

Frank