Results 1 to 3 of 3

Thread: Grouping together Like Rows

  1. Jul 11th, 2005, 01:45 PM #1
    papastyle3
    papastyle3 is offline

    Thread Starter
    New Member
    Join Date
    Jul 2005
    Location
    Connecticut
    Posts
    2

    Grouping together Like Rows

    I have a long list of data output that contains city names and information about those cities across a row. I would like to put a blank row in between city names when a change in city names occurs in a list; thus grouping together rows that have the same city name. I was using a Case statement but i don't know if I'm making it too difficult. PLEASE help. I can attach my raw data if needed.
    Reply With Quote Reply With Quote
  2. Jul 11th, 2005, 01:51 PM #2
    Bartender
    Bartender is offline
    Member
    Join Date
    Jun 2005
    Posts
    41

    Re: Grouping together Like Rows

    Excel itself has a subtotal function that sounds like what you might need?
    Try Data-->Subtotals, and see if that does what you need it to do?
    Reply With Quote Reply With Quote
  3. Jul 11th, 2005, 05:52 PM #3
    papastyle3
    papastyle3 is offline

    Thread Starter
    New Member
    Join Date
    Jul 2005
    Location
    Connecticut
    Posts
    2

    Exclamation Re: Grouping together Like Rows

    Unfortunetly that option doesn't work because I need a blank row in between any change in City names. The Subtotal option can only create a page break, and the I do not need to incorporate any funtions like Sum, etc. Any more ideas....?
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width