+ Reply to Thread
Results 1 to 4 of 4

Reorder rows content for each row

  1. #1
    Registered User
    Join Date
    11-21-2012
    Location
    Spain
    MS-Off Ver
    Excel Mac 2008
    Posts
    14

    Reorder rows content for each row

    Hi there,
    First of all, I'm sorry because I don't know if I can explain this in a understandable way (I don't know how to search for it). And maybe is not posible.

    I'll have a file with electoral results with this structure (simplified):
    Please Login or Register  to view this content.
    Example with PartyA, PartyB, PartyC:
    Please Login or Register  to view this content.
    The problem is that parties are ordered in each row from most voted to less voted. So the order of parties change in each row according to the amount of votes.
    The ideal output format for me is this, where each column has data for the same party:

    Please Login or Register  to view this content.
    After that, I'll do some calculations and comparisons with Excel.

    Is this posible?
    Thank you!

  2. #2
    Valued Forum Contributor
    Join Date
    07-07-2014
    Location
    Washington DC
    MS-Off Ver
    2007
    Posts
    1,047

    Re: Reorder rows content for each row

    It's not exactly elegant, but you could use some vlookups to reorganize the votes like this. Just create additional rows for the additional parties.
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    11-21-2012
    Location
    Spain
    MS-Off Ver
    Excel Mac 2008
    Posts
    14

    Re: Reorder rows content for each row

    Thank you, hoyasaxa215
    Doesn't matter the elegance, if it works!

    I'm fighting with putting formulas in the original and complex Excel, but it looks promising.

    Thank you!

  4. #4
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Reorder rows content for each row

    Is this a system where the voter votes for first choice by preference then second choice by preference then third choice by preference...etc?
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Copy & Reorder Columns of Rows That Meet Criteria
    By stusic in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-14-2015, 11:19 AM
  2. reorder paired data in rows
    By rebelbuttmunch in forum Excel General
    Replies: 3
    Last Post: 04-29-2014, 06:12 AM
  3. [SOLVED] Reorder Rows and Sum column totals given specified criteria
    By bwmuhich in forum Excel General
    Replies: 5
    Last Post: 04-09-2014, 03:58 PM
  4. [SOLVED] Refreshing Pivot Table fails to reorder the rows
    By DHughston in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 03-28-2014, 05:05 PM
  5. Can I reorder rows with locked cells?
    By mrgrotey in forum Excel General
    Replies: 3
    Last Post: 01-04-2013, 10:34 AM
  6. Reorder Rows where sort is ineffective
    By Orada in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-29-2011, 04:06 PM
  7. Reorder rows & copy to new sheet
    By mernst in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 08-27-2009, 10:31 AM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1