+ Reply to Thread
Results 1 to 4 of 4

Transpose multiple columns into rows

  1. #1
    Registered User
    Join Date
    01-26-2020
    Location
    Amsterdam
    MS-Off Ver
    16
    Posts
    17

    Transpose multiple columns into rows

    Dear all,

    I want to transfer/transpose large number of columns into rows (while maintaining the code column for each row). I have attached an excel as an example. Unfortunately I don't have the power query from excel since I run Excel on Mac. I run Excel version 16.38. Any way how I can do this? I have limited Excel knowledge but I know how to run a VBA code. Thanks in advance for the help!
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Excel 2016
    Posts
    13,764

    Re: Transpose multiple columns into rows

    With the code below.

    See the attached file.

    Please Login or Register  to view this content.
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  3. #3
    Registered User
    Join Date
    01-26-2020
    Location
    Amsterdam
    MS-Off Ver
    16
    Posts
    17

    Re: Transpose multiple columns into rows

    Dear Oeldere,

    Many, many thanks for this quick solution! It works like a charm on my entire excel. Great work!

  4. #4
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Excel 2016
    Posts
    13,764

    Re: Transpose multiple columns into rows

    Glad I could help.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

+ 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. Replies: 1
    Last Post: 01-24-2014, 06:20 PM
  2. [SOLVED] Transpose Multiple Rows to Columns
    By pjscho in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-09-2013, 10:00 AM
  3. Transpose columns into multiple rows
    By taylorj3 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-14-2013, 07:41 PM
  4. Replies: 4
    Last Post: 03-08-2013, 09:49 AM
  5. [SOLVED] How to transpose non-uniform data in multiple columns into multiple rows?
    By alexxgalaxy in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-03-2013, 08:40 PM
  6. Multiple transpose function from rows into columns
    By fletchy888 in forum Excel General
    Replies: 10
    Last Post: 09-27-2011, 09:23 AM
  7. transpose multiple rows into two columns
    By thane in forum Excel General
    Replies: 2
    Last Post: 09-14-2010, 12:48 AM
  8. transpose multiple rows and columns
    By prawer in forum Excel General
    Replies: 2
    Last Post: 06-03-2009, 04:20 PM

Tags for this Thread

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