Sorting Data

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mark - 20 Mar 2008 02:51 GMT

Is there formula or anyway to be able sort the below data into a format that
I could create a pivot table on? I spend to many hours doing this every month.

Invoice #:    12345    Invoice Date:    1/16/1950    A/P Code:    ABC
Due Date:    1/16/1950    Total Payable:    $100.00     Reference:    Freight:
Account #:    1234    Description:    Name Reference 1    Amount:    $100.00
Account #:    4321    Description:    Name Reference 2    Amount:    $100.00
Account #:    9876    Description:    Name Reference 3    Amount:    $100.00

Any help would be much appreciated!!

Reply to this Message

Jim Cone - 20 Mar 2008 20:26 GMT

You need to show a Before and After version.
You still might not get any help, but your chances will be better.

Signature

Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)

"Mark"
wrote in message
Is there formula or anyway to be able sort the below data into a format that
I could create a pivot table on? I spend to many hours doing this every month.

Invoice #: 12345 Invoice Date: 1/16/1950 A/P Code: ABC
Due Date: 1/16/1950 Total Payable: $100.00 Reference: Freight:
Account #: 1234 Description: Name Reference 1 Amount: $100.00
Account #: 4321 Description: Name Reference 2 Amount: $100.00
Account #: 9876 Description: Name Reference 3 Amount: $100.00

Any help would be much appreciated!!

Reply to this Message

Rate this thread: