Results 1 to 18 of 18

How to interchange cell values with column names in a data table in Excel

Threaded View

  1. 12-21-2021, 12:42 PM #1
    rnexcel
    rnexcel is offline
    Registered User
    Join Date
    12-21-2021
    Location
    New Delhi, India
    MS-Off Ver
    2019
    Posts
    8

    How to interchange cell values with column names in a data table in Excel

    I have following data of 3 persons posted at 3 places on 3 days of the week:

    JRb8L.png
                    Tom	Dik 	Harry
Monday	        Cafe	Library	Gym
Tuesday	        Library	Gym	Cafe
Wednesday	Gym	Cafe	Library
    I want to convert above data to following table format:

    prk2Z.png
                    Cafe	Library	Gym
Monday			
Tuesday			
Wednesday
    The cells of new table should get filled automatically using data in first table.

    How can this be done?
    Last edited by rnexcel; 12-21-2021 at 01:20 PM.
    Reply With QuoteRegister To Reply
« 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] Looping throuhg sheets to interchange values
    By EverGreen1231 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-29-2014, 09:46 AM
  2. Data from one column to another - Matching names and values (complex)
    By fetow in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-12-2014, 11:38 PM
  3. How to fetch first few values or names from excel column
    By meetvivek72 in forum Excel General
    Replies: 5
    Last Post: 02-13-2014, 06:48 AM
  4. need excel formula to get result from data table depends upon week,partner,column values
    By breadwinner in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-13-2013, 08:41 AM
  5. Writing to cell in table based on column and row names
    By teacher_rob in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-09-2011, 11:17 PM
  6. Interchange symbols in a column
    By kamalthakur in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-15-2010, 04:15 AM
  7. [SOLVED] How do I have a data table display cell names rather than values?
    By raortiz99 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-09-2005, 12: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