+ Reply to Thread
Results 1 to 6 of 6

Sort side-by-side

  1. 07-11-2020, 12:14 PM #1
    lemonap618
    lemonap618 is offline
    Forum Contributor
    Join Date
    02-06-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    112

    Sort side-by-side

    Hello All,
    I hope this message finds everyone happy and healthy!
    I received the following instructions from my colleague to " Sort the file by employee number so all records for each unique employee are side by side."
    I admittedly do not know how to sort side by side. Has anyone done this before?
    Any and all help is much appreciated!

    Thanks!
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 07-11-2020, 12:17 PM #2
    AliGW
    AliGW is online now
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,933

    Re: Sort side-by-side

    What do you expect 'side-by-side' to look like?
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
  3. 07-11-2020, 01:00 PM #3
    Kaper
    Kaper is offline
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,623

    Re: Sort side-by-side

    Trying to guess what could be this side-by-side sort I wrote short VBA code:

    Please Login or Register  to view this content.
    open attached file (enable macros) and run (Alt+F8 and Run) macro test
    Attached Files Attached Files
    Best Regards,

    Kaper
    Reply With QuoteRegister To Reply
  4. 07-11-2020, 01:05 PM #4
    lemonap618
    lemonap618 is offline
    Forum Contributor
    Join Date
    02-06-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    112

    Re: Sort side-by-side

    Hello Ali,
    I would like the unique employee number at the top row and then the other measures on the x axis...similar to this.
    Thanks!

    2020-07-11_1203.png2020-07-11_1203.png
    Reply With QuoteRegister To Reply
  5. 07-11-2020, 01:15 PM #5
    AliGW
    AliGW is online now
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,933

    Re: Sort side-by-side

    Which version of Excel are you using?

    The attached is done with PowerQuery - simply demote headers and transpose.
    Attached Files Attached Files
    Last edited by AliGW; 07-11-2020 at 01:19 PM.
    Reply With QuoteRegister To Reply
  6. 07-11-2020, 02:37 PM #6
    lemonap618
    lemonap618 is offline
    Forum Contributor
    Join Date
    02-06-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    112

    Re: Sort side-by-side

    thank you so much!!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] How to create a month and Year-to-date column side by side in pivot table
    By Dewdrop in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 06-13-2017, 02:25 AM
  2. Having 'Actual' or 'Forecast' series side by side with 'Budget' with similar height size
    By dluhut in forum Excel Charting & Pivots
    Replies: 11
    Last Post: 05-17-2017, 12:52 PM
  3. Compare 2 sets of values in side-by-side Stacked Column chart
    By dlaudenschlager in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 03-21-2016, 01:34 PM
  4. [SOLVED] Set Excel 2010 as default program when installed side-by-side with 2013
    By AlvaroSiza in forum Excel General
    Replies: 1
    Last Post: 08-31-2013, 06:45 PM
  5. VBA to copy data from multiple sheets side-by-side into one sheet matching date
    By MHCapcog in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 04-02-2013, 06:11 PM
  6. Cause bound Text Boxs to appear side-by-side on form or report result for each record
    By LLEW11 in forum Access Programming / VBA / Macros
    Replies: 0
    Last Post: 04-19-2009, 10:53 PM
  7. Display columns side by Side in the Data Area of a Pivot table
    By Sue in forum Excel General
    Replies: 1
    Last Post: 03-20-2006, 10:15 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1