+ Reply to Thread
Results 1 to 2 of 2

Help Sorting Data

  1. #1
    Registered User
    Join Date
    05-29-2017
    Location
    Washington
    MS-Off Ver
    2010
    Posts
    1

    Help Sorting Data

    I have a large data set of every nfl game from the 2016 season. The data is formatted so that I have all 16 games under every nfl team. The issue is, since I have every team and all of their games, there are two rows for every game played (one row under each team). I would like to sort the data so that these two rows will be next to each other in my data set.Screen Shot 2017-05-29 at 3.48.50 PM.png
    Last edited by jdog96; 05-29-2017 at 03:50 PM.

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,873

    Re: Help Sorting Data

    Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

+ 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. Replies: 1
    Last Post: 12-16-2015, 01:04 PM
  2. Replies: 0
    Last Post: 02-24-2014, 11:27 AM
  3. Sorting all data based on data in single column (DATES)
    By subbby in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-16-2013, 08:19 AM
  4. [SOLVED] Data Analysis: Comparing 3 columns, sorting, removing unique values, display data
    By kmills2626 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 10-14-2013, 07:27 AM
  5. Sorting 2 data ranges by comparing one column in each and sorting to match
    By MDKsmiffy in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-17-2013, 03:30 PM
  6. Replies: 3
    Last Post: 12-20-2012, 06:16 AM
  7. Sorting, finding dulicates, moving one data element up, deleting original data
    By rickwtx in forum Excel Programming / VBA / Macros
    Replies: 22
    Last Post: 01-13-2011, 07:32 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1