+ Reply to Thread
Results 1 to 6 of 6

How to Transpose a Table in Excel

  1. #1
    Forum Contributor
    Join Date
    09-18-2015
    Location
    Republic of Korea
    MS-Off Ver
    2010
    Posts
    314

    How to Transpose a Table in Excel

    Snap28.png

    I want to make the left table the right table.

    https://www.excelguru.ca/forums/show...0745-Transpose
    Attached Files Attached Files
    Last edited by chief_abound; 07-28-2020 at 08:28 AM.

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,164

    Re: How to Transpose a Table in Excel

    Hi chief,

    Instead of doing like you show, try using a pivot table. Your example right table is bad as it has column heads the same word.
    See this attached for an example: Transpose - use Pivot.xlsx
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  3. #3
    Forum Contributor
    Join Date
    09-18-2015
    Location
    Republic of Korea
    MS-Off Ver
    2010
    Posts
    314

    Re: How to Transpose a Table in Excel

    Thank you so much!

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

    Re: How to Transpose a Table in Excel

    Administrative Note:

    Welcome to the forum.

    We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

    Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

    (Note: this requirement is not optional. No help to be offered until the link is provided.)
    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

  5. #5
    Forum Contributor
    Join Date
    09-18-2015
    Location
    Republic of Korea
    MS-Off Ver
    2010
    Posts
    314

    Re: How to Transpose a Table in Excel

    I will be careful.

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

    Re: How to Transpose a Table in Excel

    Being careful is not enough. You need to provide the link to other forums where you have crossposted.

+ 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. To transpose or not to transpose? What decides? Table / Array?
    By LIL2606 in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 02-19-2019, 01:28 PM
  2. Replies: 4
    Last Post: 08-21-2018, 09:24 AM
  3. [SOLVED] Transpose horizontal table to a vertical table via query
    By Journeyman3000 in forum Access Tables & Databases
    Replies: 5
    Last Post: 12-03-2015, 10:21 PM
  4. Sum and conditional transpose of Excel table data
    By kc-s in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-06-2015, 11:39 AM
  5. Replies: 4
    Last Post: 01-25-2015, 01:35 PM
  6. transpose column to a range calculate and transpose to new table loop
    By moshro1 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-02-2015, 10:52 AM
  7. How to rotate a data Table in Excel 2010? (NOT TRANSPOSE)
    By jamonzonv in forum Excel General
    Replies: 1
    Last Post: 09-23-2013, 06:12 AM

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