Results 1 to 9 of 9

Making a list of the row title under the corresponding column title in if a cell has X

Threaded View

  1. #1
    Registered User
    Join Date
    02-06-2019
    Location
    Charleston, SC
    MS-Off Ver
    MS Office 2016
    Posts
    4

    Making a list of the row title under the corresponding column title in if a cell has X

    Sorry for the confusing title, I couldn't think of a concise way to summarize what I want to do. I want to have an input table with the column titles being the title of something and the row names as the names of people. The idea is, when the cell contains something, probably an X, a separate table with the same column titles will populate a list of the names X'ed in the corresponding column. Below I have attempted to make some tables with what I imagine it looking like.

    Input table where cells are X'ed as needed.
    1000.1A 2000.2B 3000.3C
    Smith X
    Jones X X
    Williams X X X


    Output table where the list is generated based on the X's
    1000.1A 2000.2B 3000.3C
    Williams Jones Jones
    Williams Smith
    Williams


    I am able to get the names as an output to the correct column, but I do not know how to move them up to the top-most open space. Right now I am using =IF(B2<>"",A1,"") to get the name in the appropriate list. But as you can see, it will leave an empty space for that row under the output column. This is where I get stuck trying to squish it up to the top.

    Also, as a separate note, I would like to sort them by alphabetical order when they are in that column.

    Any help is much appreciated.
    Last edited by Poss273; 02-06-2019 at 12:51 PM. Reason: Clarifying to show that column titles are not to be confused with the standard titles shown in Excel

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Search a sheet for a song title and return Album title
    By A440 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 10-28-2016, 10:19 AM
  2. [SOLVED] Help making a chart title from cell contents.
    By maurerma in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 01-10-2014, 04:06 PM
  3. Replies: 4
    Last Post: 10-19-2012, 12:09 PM
  4. Replies: 12
    Last Post: 08-10-2012, 05:11 PM
  5. Replies: 2
    Last Post: 07-05-2007, 11:07 AM
  6. [SOLVED] Named range=Column title,comumn title in cellB6 use B6in equation
    By Graham in forum Excel General
    Replies: 2
    Last Post: 07-21-2006, 05:10 AM
  7. Pasting Objects into Chart title and Axis title
    By Sam in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-06-2005, 04:05 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