+ Reply to Thread
Results 1 to 6 of 6

transposing a table

  1. 03-16-2016, 08:27 AM #1
    samyraj
    samyraj is offline
    Registered User
    Join Date
    03-16-2016
    Location
    London
    MS-Off Ver
    Office 2021
    Posts
    67

    transposing a table

    Hi

    Can someone help with the below .

    I have a data set as below (This is just an extract of the table there are more rows and coloumns in the actual data set) Table 1 and I want to transpose the data set to produce a table as Table 2

    Table.JPG

    Thanks
    Attached Images Attached Images
    Reply With QuoteRegister To Reply
  2. 03-16-2016, 09:05 AM #2
    Special-K
    Special-K is offline
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,064

    Re: transposing a table

    This works, output on Sheet2

    Please Login or Register  to view this content.
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
    Reply With QuoteRegister To Reply
  3. 03-16-2016, 09:22 AM #3
    Kaper
    Kaper is offline
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,623

    Re: transposing a table

    One of my favourite tricks to do it manually is: https://www.youtube.com/watch?v=pUXJLzqlEPk
    Best Regards,

    Kaper
    Reply With QuoteRegister To Reply
  4. 03-16-2016, 09:23 AM #4
    samyraj
    samyraj is offline
    Registered User
    Join Date
    03-16-2016
    Location
    London
    MS-Off Ver
    Office 2021
    Posts
    67

    Re: transposing a table

    Thanks a lot , you are a star
    Reply With QuoteRegister To Reply
  5. 03-16-2016, 11:30 AM #5
    newdoverman
    newdoverman is offline
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: transposing a table

    @ Kaper

    That is cleaver!!
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W
    Reply With QuoteRegister To Reply
  6. 03-16-2016, 11:39 AM #6
    Kaper
    Kaper is offline
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,623

    Re: transposing a table

    Thanks Ron for noticing that,

    I loved from the first sight this pawky idea of using pivot to unpivot data :-)
    Reply With QuoteRegister To Reply
+ Reply to Thread
« 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] Transposing Info or Pivot Table???
    By Cmorgan in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 03-09-2014, 04:14 PM
  2. Transposing and consolidating a 1d to a 2d table
    By danberg2 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-09-2013, 05:04 PM
  3. [SOLVED] Transposing table
    By justMartin in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-11-2012, 03:29 PM
  4. Pivot table/transposing columns
    By cooter_slackjaw in forum Excel General
    Replies: 2
    Last Post: 09-25-2012, 06:27 AM
  5. Transposing a table view
    By ElmerS in forum Excel General
    Replies: 11
    Last Post: 10-31-2009, 04:45 AM
  6. Transposing a table
    By ElmerS in forum Excel General
    Replies: 9
    Last Post: 07-14-2009, 03:00 PM
  7. Transposing a table
    By KH_GS in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-22-2007, 12:10 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