+ Reply to Thread
Results 1 to 10 of 10

Need to transpose values

  1. #1
    Registered User
    Join Date
    09-23-2016
    Location
    seattle, wa
    MS-Off Ver
    2013
    Posts
    7

    Need to transpose values

    Hello support group,
    Here is my issue. I have a file in this format with cities in column A and then count across other columns
    Name Q116 Q216 Q316 Q416 Q117 Q217 Q317 Q417
    city1 10 20 30 40 50 60 70 80
    city2 1 2 2 2 2 3 4 5

    I need my new sheet like this
    city1 Q116 10
    CITY1 Q216 20
    CITY1 q316 30
    city1 q416 40
    city1 q117 50
    city1 q217 60
    city1 q317 70
    city1 q417 80
    ..... same for city 2

    Please help!

    Thanks in advance,
    Shravani

  2. #2
    Forum Expert
    Join Date
    10-06-2008
    Location
    Canada
    MS-Off Ver
    2007 / 2013
    Posts
    4,794

    Re: Need to transpose values

    Maybe attach a workbook with a before and after.
    Sanitize, no personal info, before attaching

  3. #3
    Registered User
    Join Date
    09-23-2016
    Location
    seattle, wa
    MS-Off Ver
    2013
    Posts
    7

    Re: Need to transpose values

    i created a new post with attachment
    http://www.excelforum.com/showthread...50#post4495250

  4. #4
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... based in Ireland... but I could be anywhere in the world
    MS-Off Ver
    O365 (PC) V 2211
    Posts
    35,790

    Re: Need to transpose values

    Are you OK with a formula:

    In L2
    =OFFSET($A$2,INT(ROWS($L$2:L2)-1)/8,,,)

    In M2
    =OFFSET($B$1,,MOD(ROWS($M$2:M2)-1,8),,)

    In N2
    =OFFSET($B$2,INT(ROWS($N$2:N2)-1)/8,MOD(ROWS($N$2:N2)-1,8),,)

    All copied down.
    Attached Files Attached Files
    Glenn



  5. #5
    Registered User
    Join Date
    09-23-2016
    Location
    seattle, wa
    MS-Off Ver
    2013
    Posts
    7

    Re: Need to transpose values

    Thank you Glenn!
    Formula works for me

    Thanks,
    Shravani

  6. #6
    Registered User
    Join Date
    09-23-2016
    Location
    seattle, wa
    MS-Off Ver
    2013
    Posts
    7

    Re: Need to transpose values

    Thank you Glenn!
    Formula works for me

    Thanks,
    Shravani

  7. #7
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... based in Ireland... but I could be anywhere in the world
    MS-Off Ver
    O365 (PC) V 2211
    Posts
    35,790

    Re: Need to transpose values

    Great! I'm glad to have helped! If that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.
    Last edited by Glenn Kennedy; 10-04-2016 at 03:03 PM.

  8. #8
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,840

    Re: Need to transpose values

    Using code try this
    Please Login or Register  to view this content.
    < ----- Please click the little star * next to add reputation if my post helps you
    Visit Forum : From Here

  9. #9
    Forum Expert
    Join Date
    10-06-2008
    Location
    Canada
    MS-Off Ver
    2007 / 2013
    Posts
    4,794

    Re: Need to transpose values

    Yasser
    I would change these 2 lines
    Please Login or Register  to view this content.
    to
    Please Login or Register  to view this content.
    to keep it more flexible.
    and if you want slightly less looping
    Please Login or Register  to view this content.

  10. #10
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,840

    Re: Need to transpose values

    That's great Mr. Jolivanes
    Thanks for this helpful solution
    Best Regards

+ 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. Transpose Values
    By hpatel517 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-07-2016, 02:42 PM
  2. [SOLVED] Transpose values
    By tangomj in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-28-2015, 02:39 PM
  3. [SOLVED] Transpose a long column into delimiters separated values according to values in input box
    By prkhan56 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-27-2014, 01:32 PM
  4. [SOLVED] transpose values into one row
    By artefarct in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 11-01-2014, 03:04 AM
  5. [SOLVED] Transpose values
    By leovilla in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-02-2013, 08:11 AM
  6. Transpose values ???
    By brooklyn in forum Excel General
    Replies: 0
    Last Post: 06-06-2007, 07:43 PM
  7. I WANT TO TRANSPOSE LINKS, AS WE TRANSPOSE VALUES
    By Umair Aslam in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-22-2005, 09:05 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