Excel Newbie...How To Re-Order Data

M

Martin

Hello,

I'm 100% new to Excel (btw, I have Excel 2002) and need assistance with the
following, please.

I have an Excel spreadsheet, running many hundreds of pages, that has 7
columns.

They are, from left to right, as follows:

1. Person's name
2. Person's street address
3. Person's city
4. Person's state
5. Person's Zip code
6. Reference number assigned to the person
7. Monetary amount

The *current* spreadsheet is neither in alphabetical nor numerical order.

For example, 3 consecutive entries may appear as:

Poe, John 895 Main Street New York NY 10120 753 6.20
Allan, David 456 Pear Ave Iselin NJ 08830 421 342.57
Doe, Jane 567 Oscar Street Atlanta GA 77731 525 1.23

What I would like to do is re-order the spreadsheet by *monetary amount*, as
long as the data associated with each amount is maintained by the same
re-ordering.

To be more specific, I wish the spreadsheet to appear as:

Doe, Jane 567 Oscar Street Atlanta GA 77731 525 1.23
Poe, John 895 Main Street New York NY 10120 753 6.20
Allan, David 456 Pear Ave Iselin NJ 08830 421 342.57

OR

Allan, David 456 Pear Ave Iselin NJ 08830 421 342.57
Poe, John 895 Main Street New York NY 10120 753 6.20
Doe, Jane 567 Oscar Street Atlanta GA 77731 525 1.23

Any help would be greatly appreciated!

Thank you.

Martin
 
D

David Biddulph

Select your data range, including all the relevant rows and columns. Then
Data/ Sort by .../ and choose the relevant column by which to sort.
 
M

Martin

Hello David,

Thank you very much for the instructions.

I thought that the re-ordering would be quite difficult to achieve. On the
contrary, your instructions made it quite easy.

Much appreciated!

Regards,

Martin

"David Biddulph" <groups [at] biddulph.org.uk> wrote in message
| Select your data range, including all the relevant rows and columns. Then
| Data/ Sort by .../ and choose the relevant column by which to sort.
| --
| David Biddulph
|
| | > Hello,
| >
| > I'm 100% new to Excel (btw, I have Excel 2002) and need assistance with
| > the
| > following, please.
| >
| > I have an Excel spreadsheet, running many hundreds of pages, that has 7
| > columns.
| >
| > They are, from left to right, as follows:
| >
| > 1. Person's name
| > 2. Person's street address
| > 3. Person's city
| > 4. Person's state
| > 5. Person's Zip code
| > 6. Reference number assigned to the person
| > 7. Monetary amount
| >
| > The *current* spreadsheet is neither in alphabetical nor numerical
order.
| >
| > For example, 3 consecutive entries may appear as:
| >
| > Poe, John 895 Main Street New York NY 10120 753 6.20
| > Allan, David 456 Pear Ave Iselin NJ 08830 421 342.57
| > Doe, Jane 567 Oscar Street Atlanta GA 77731 525 1.23
| >
| > What I would like to do is re-order the spreadsheet by *monetary
amount*,
| > as
| > long as the data associated with each amount is maintained by the same
| > re-ordering.
| >
| > To be more specific, I wish the spreadsheet to appear as:
| >
| > Doe, Jane 567 Oscar Street Atlanta GA 77731 525 1.23
| > Poe, John 895 Main Street New York NY 10120 753 6.20
| > Allan, David 456 Pear Ave Iselin NJ 08830 421 342.57
| >
| > OR
| >
| > Allan, David 456 Pear Ave Iselin NJ 08830 421 342.57
| > Poe, John 895 Main Street New York NY 10120 753 6.20
| > Doe, Jane 567 Oscar Street Atlanta GA 77731 525 1.23
| >
| > Any help would be greatly appreciated!
| >
| > Thank you.
| >
| > Martin
| >
| >
| >
|
|
 
M

Martin

Hello David and/or whomever else reads this post:

In addition to Excel spreadsheets as described below, I also have PDF files
with the same type of information and in the same format from left to right.

Just as with the Excel spreadsheet, the monetary amounts are neither in
ascending or descending order; they are in random "order".

Is there any way, even if quite difficult, to modify a PDF file so that its
contents will be similar to those of a spreadsheet after re-ordering?

Once again, thank you for any assistance provided!

Regards,

Martin

| Hello David,
|
| Thank you very much for the instructions.
|
| I thought that the re-ordering would be quite difficult to achieve. On the
| contrary, your instructions made it quite easy.
|
| Much appreciated!
|
| Regards,
|
| Martin
|
| "David Biddulph" <groups [at] biddulph.org.uk> wrote in message
| || Select your data range, including all the relevant rows and columns.
Then
|| Data/ Sort by .../ and choose the relevant column by which to sort.
|| --
|| David Biddulph
||
|| || > Hello,
|| >
|| > I'm 100% new to Excel (btw, I have Excel 2002) and need assistance with
|| > the
|| > following, please.
|| >
|| > I have an Excel spreadsheet, running many hundreds of pages, that has 7
|| > columns.
|| >
|| > They are, from left to right, as follows:
|| >
|| > 1. Person's name
|| > 2. Person's street address
|| > 3. Person's city
|| > 4. Person's state
|| > 5. Person's Zip code
|| > 6. Reference number assigned to the person
|| > 7. Monetary amount
|| >
|| > The *current* spreadsheet is neither in alphabetical nor numerical
| order.
|| >
|| > For example, 3 consecutive entries may appear as:
|| >
|| > Poe, John 895 Main Street New York NY 10120 753 6.20
|| > Allan, David 456 Pear Ave Iselin NJ 08830 421 342.57
|| > Doe, Jane 567 Oscar Street Atlanta GA 77731 525 1.23
|| >
|| > What I would like to do is re-order the spreadsheet by *monetary
| amount*,
|| > as
|| > long as the data associated with each amount is maintained by the same
|| > re-ordering.
|| >
|| > To be more specific, I wish the spreadsheet to appear as:
|| >
|| > Doe, Jane 567 Oscar Street Atlanta GA 77731 525 1.23
|| > Poe, John 895 Main Street New York NY 10120 753 6.20
|| > Allan, David 456 Pear Ave Iselin NJ 08830 421 342.57
|| >
|| > OR
|| >
|| > Allan, David 456 Pear Ave Iselin NJ 08830 421 342.57
|| > Poe, John 895 Main Street New York NY 10120 753 6.20
|| > Doe, Jane 567 Oscar Street Atlanta GA 77731 525 1.23
|| >
|| > Any help would be greatly appreciated!
|| >
|| > Thank you.
|| >
|| > Martin
|| >
|| >
|| >
||
||
|
|
 
G

Gord Dibben

You could import/copy the PDF into Excel, do the sorting and save as a new PDF
file.

Here are some tips from David McRitchie

http://www.mvps.org/dmcritchie/excel/pdf.htm

http://kenchiro.tripod.com/howtoPDF.html


Gord Dibben MS Excel MVP

Hello David and/or whomever else reads this post:

In addition to Excel spreadsheets as described below, I also have PDF files
with the same type of information and in the same format from left to right.

Just as with the Excel spreadsheet, the monetary amounts are neither in
ascending or descending order; they are in random "order".

Is there any way, even if quite difficult, to modify a PDF file so that its
contents will be similar to those of a spreadsheet after re-ordering?

Once again, thank you for any assistance provided!

Regards,

Martin

| Hello David,
|
| Thank you very much for the instructions.
|
| I thought that the re-ordering would be quite difficult to achieve. On the
| contrary, your instructions made it quite easy.
|
| Much appreciated!
|
| Regards,
|
| Martin
|
| "David Biddulph" <groups [at] biddulph.org.uk> wrote in message
| || Select your data range, including all the relevant rows and columns.
Then
|| Data/ Sort by .../ and choose the relevant column by which to sort.
|| --
|| David Biddulph
||
|| || > Hello,
|| >
|| > I'm 100% new to Excel (btw, I have Excel 2002) and need assistance with
|| > the
|| > following, please.
|| >
|| > I have an Excel spreadsheet, running many hundreds of pages, that has 7
|| > columns.
|| >
|| > They are, from left to right, as follows:
|| >
|| > 1. Person's name
|| > 2. Person's street address
|| > 3. Person's city
|| > 4. Person's state
|| > 5. Person's Zip code
|| > 6. Reference number assigned to the person
|| > 7. Monetary amount
|| >
|| > The *current* spreadsheet is neither in alphabetical nor numerical
| order.
|| >
|| > For example, 3 consecutive entries may appear as:
|| >
|| > Poe, John 895 Main Street New York NY 10120 753 6.20
|| > Allan, David 456 Pear Ave Iselin NJ 08830 421 342.57
|| > Doe, Jane 567 Oscar Street Atlanta GA 77731 525 1.23
|| >
|| > What I would like to do is re-order the spreadsheet by *monetary
| amount*,
|| > as
|| > long as the data associated with each amount is maintained by the same
|| > re-ordering.
|| >
|| > To be more specific, I wish the spreadsheet to appear as:
|| >
|| > Doe, Jane 567 Oscar Street Atlanta GA 77731 525 1.23
|| > Poe, John 895 Main Street New York NY 10120 753 6.20
|| > Allan, David 456 Pear Ave Iselin NJ 08830 421 342.57
|| >
|| > OR
|| >
|| > Allan, David 456 Pear Ave Iselin NJ 08830 421 342.57
|| > Poe, John 895 Main Street New York NY 10120 753 6.20
|| > Doe, Jane 567 Oscar Street Atlanta GA 77731 525 1.23
|| >
|| > Any help would be greatly appreciated!
|| >
|| > Thank you.
|| >
|| > Martin
|| >
|| >
|| >
||
||
|
|
Click to expand...
 
M

Martin

Hello Gord,

Thank you for the instructions and links.

Being a newbie to Excel (and PDF somewhat), I hope that converting from PDF
to Excel is just as easy as re-ordering a column in Excel itself!

Regards,

Martin

"Gord Dibben" <gorddibbATshawDOTca> wrote in message
| You could import/copy the PDF into Excel, do the sorting and save as a new
PDF
| file.
|
| Here are some tips from David McRitchie
|
| http://www.mvps.org/dmcritchie/excel/pdf.htm
|
| http://kenchiro.tripod.com/howtoPDF.html
|
|
| Gord Dibben MS Excel MVP
|
| On Sun, 15 Jul 2007 16:01:15 GMT, "Martin" <[email protected]>
wrote:
|
| >Hello David and/or whomever else reads this post:
| >
| >In addition to Excel spreadsheets as described below, I also have PDF
files
| >with the same type of information and in the same format from left to
right.
| >
| >Just as with the Excel spreadsheet, the monetary amounts are neither in
| >ascending or descending order; they are in random "order".
| >
| >Is there any way, even if quite difficult, to modify a PDF file so that
its
| >contents will be similar to those of a spreadsheet after re-ordering?
| >
| >Once again, thank you for any assistance provided!
| >
| >Regards,
| >
| >Martin
| >
| >| >| Hello David,
| >|
| >| Thank you very much for the instructions.
| >|
| >| I thought that the re-ordering would be quite difficult to achieve. On
the
| >| contrary, your instructions made it quite easy.
| >|
| >| Much appreciated!
| >|
| >| Regards,
| >|
| >| Martin
| >|
| >| "David Biddulph" <groups [at] biddulph.org.uk> wrote in message
| >| | >|| Select your data range, including all the relevant rows and columns.
| >Then
| >|| Data/ Sort by .../ and choose the relevant column by which to sort.
| >|| --
| >|| David Biddulph
| >||
| >|| | >|| > Hello,
| >|| >
| >|| > I'm 100% new to Excel (btw, I have Excel 2002) and need assistance
with
| >|| > the
| >|| > following, please.
| >|| >
| >|| > I have an Excel spreadsheet, running many hundreds of pages, that
has 7
| >|| > columns.
| >|| >
| >|| > They are, from left to right, as follows:
| >|| >
| >|| > 1. Person's name
| >|| > 2. Person's street address
| >|| > 3. Person's city
| >|| > 4. Person's state
| >|| > 5. Person's Zip code
| >|| > 6. Reference number assigned to the person
| >|| > 7. Monetary amount
| >|| >
| >|| > The *current* spreadsheet is neither in alphabetical nor numerical
| >| order.
| >|| >
| >|| > For example, 3 consecutive entries may appear as:
| >|| >
| >|| > Poe, John 895 Main Street New York NY 10120 753 6.20
| >|| > Allan, David 456 Pear Ave Iselin NJ 08830 421 342.57
| >|| > Doe, Jane 567 Oscar Street Atlanta GA 77731 525 1.23
| >|| >
| >|| > What I would like to do is re-order the spreadsheet by *monetary
| >| amount*,
| >|| > as
| >|| > long as the data associated with each amount is maintained by the
same
| >|| > re-ordering.
| >|| >
| >|| > To be more specific, I wish the spreadsheet to appear as:
| >|| >
| >|| > Doe, Jane 567 Oscar Street Atlanta GA 77731 525 1.23
| >|| > Poe, John 895 Main Street New York NY 10120 753 6.20
| >|| > Allan, David 456 Pear Ave Iselin NJ 08830 421 342.57
| >|| >
| >|| > OR
| >|| >
| >|| > Allan, David 456 Pear Ave Iselin NJ 08830 421 342.57
| >|| > Poe, John 895 Main Street New York NY 10120 753 6.20
| >|| > Doe, Jane 567 Oscar Street Atlanta GA 77731 525 1.23
| >|| >
| >|| > Any help would be greatly appreciated!
| >|| >
| >|| > Thank you.
| >|| >
| >|| > Martin
| >|| >
| >|| >
| >|| >
| >||
| >||
| >|
| >|
| >
|
 
Top