+ Reply to Thread
Results 1 to 4 of 4

Transposing certain rows into columns

  1. #1
    Registered User
    Join Date
    01-15-2019
    Location
    washington, DC
    MS-Off Ver
    MS Office 365 ProPlus
    Posts
    5

    Transposing certain rows into columns

    export.PNG

    This export has three columns. The third column reflects inputs and may contain 13 answers--each of which is then reflected as a separate row in the table. (file attached: export)

    The desire is for each of the rows to be reflected in the same row, but a column for each answer. The perfect output looks like this (file attached: desire)
    desire.PNG

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Excel 2007
    Posts
    17,400

    Re: Transposing certain rows into columns

    You haven't attached Excel workbook - you've attached pictures of one, which can't be worked on or edited. It would be better if you attached a sample Excel workbook.

    To do this, click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and then on Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post. Don't try to use the Paperclip icon, as it doesn't work on this forum.

    Hope this helps.

    Pete

  3. #3
    Registered User
    Join Date
    01-15-2019
    Location
    washington, DC
    MS-Off Ver
    MS Office 365 ProPlus
    Posts
    5

    Re: Transposing certain rows into columns

    I apologize for not including the sample excel. I believe I have uploaded it now.
    Attached Files Attached Files

  4. #4
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 2019
    Posts
    15,298

    Re: Transposing certain rows into columns

    You can do this through Power Query/ Get and Transform. Upload your file to PQ, Click on the column to be transposed. Click on Unpivot this column. Click on Home and Close and Upload..

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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