+ Reply to Thread
Results 1 to 3 of 3

How to sort columns in table independently of each other?

  1. #1
    Registered User
    Join Date
    02-19-2019
    Location
    United States
    MS-Off Ver
    2016
    Posts
    2

    How to sort columns in table independently of each other?

    I have a table that I am using to store multiple dynamic lists, each in their own column, that are used for a data validation list that depends on the contents of another data validated list cell.

    If that isn't clear, search for "contextures create dependent lists using tables" (it won't let me post the link, sorry). That will explain what I'm doing.

    I would like to alphabetize each column independently. Doing a sort on the whole table results in blank cells interspersed in the data in some columns, due to each column not having the same number of entries. I do not want to sort the entire rows, only the individual cells in each column.

    I understand that columns can be sorted individually when they are not part of a table, but that will not work for me. My data must be in a table in order for it to work as a dependent dynamic list. It took me several frustrating weeks to figure that out.

    This seems like such a simple thing to do, but I have not been able to figure out how to do it. Does anyone know how?

  2. #2
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    2013 / 2016 / 365
    Posts
    7,124

    Re: How to sort columns in table independently of each other?

    I can see three ways to solve this issue.

    1. Break the columns up into independent tables.

    2. Make a series of pivot tables off the master lookup table with the column header as the row header in the pivot table and then overlay the results of the pivot tables with named dynamic ranges. In this configuration, the pivot table displays a unique list of values sorted in whatever order you choose automatically. You might consider running the pivot tables of the source data so you only get values in the source data and you do not have to maintain a separate set of data just for lookup. Just remember to refresh the pivot tables when you change the source data.

    3. Depending on what you are doing, slicers might work for you.
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.

  3. #3
    Valued Forum Contributor
    Join Date
    02-02-2016
    Location
    Indonesia
    MS-Off Ver
    Office 365
    Posts
    824

    Re: How to sort columns in table independently of each other?

    If what you're trying to do is to sort the data in a certain column, why not just copy the data in that column to a range then sort it then copy back to the table.

+ 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: 02-14-2017, 03:11 PM
  2. sort coordinates independently
    By darby1981 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-25-2013, 03:37 PM
  3. Freeze Table Headers Independently
    By Phoenix5794 in forum Excel General
    Replies: 2
    Last Post: 12-07-2012, 09:14 AM
  4. Replies: 5
    Last Post: 02-22-2012, 10:08 PM
  5. Sort two columns independently
    By etienne_fra in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-12-2010, 01:28 PM
  6. how to sort many rows independently?
    By guillemot in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 12-28-2005, 12:51 PM
  7. Can you sort rows independently?
    By JXie in forum Excel General
    Replies: 2
    Last Post: 03-24-2005, 12:51 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