+ Reply to Thread
Results 1 to 9 of 9

Survey responses in multiple columns should aligned in single column against username

  1. 06-25-2022, 01:23 AM #1
    farhanahamed
    farhanahamed is offline
    Registered User
    Join Date
    02-22-2013
    Location
    bangalore
    MS-Off Ver
    Excel 2016
    Posts
    35

    Survey responses in multiple columns should aligned in single column against username

    Hi Gurus,
    I have a survey responses downloaded in excel with having 6 columns entries along with username in column A, there 6 columns with certification and completion year against user. i want all the certification completed by the user in one column after that next user. Attached the sample file for your reference. Thanks in advance. Highly appreciated. either formula or macro is accepted.

    pic1.png

    expected output should be
    pic2.png
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 06-25-2022, 01:25 AM #2
    AliGW
    AliGW is online now
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,383

    Re: Survey responses in multiple columns should aligned in single column against username

    Are you still using Excel 2016?
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
  3. 06-25-2022, 01:31 AM #3
    AliGW
    AliGW is online now
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,383

    Re: Survey responses in multiple columns should aligned in single column against username

    Here's a PowerQuery solution - all UI clicks.

    M Code:

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  4. 06-25-2022, 01:42 AM #4
    farhanahamed
    farhanahamed is offline
    Registered User
    Join Date
    02-22-2013
    Location
    bangalore
    MS-Off Ver
    Excel 2016
    Posts
    35

    Re: Survey responses in multiple columns should aligned in single column against username

    Wow that was quick response.
    Is it possible to have with excel formula or vba, because the file may used by broader community.
    Reply With QuoteRegister To Reply
  5. 06-25-2022, 01:44 AM #5
    AliGW
    AliGW is online now
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,383

    Re: Survey responses in multiple columns should aligned in single column against username

    If you answer my question first - which version of Excel are you and the broader community using?

    And why exactly would this NOT be appropriate for the broader community? Is it that YOU don't understand/use PQ?
    Reply With QuoteRegister To Reply
  6. 06-25-2022, 01:51 AM #6
    farhanahamed
    farhanahamed is offline
    Registered User
    Join Date
    02-22-2013
    Location
    bangalore
    MS-Off Ver
    Excel 2016
    Posts
    35

    Re: Survey responses in multiple columns should aligned in single column against username

    Yes, we using Excel 2016, i know about power Query, but not in my company, they want the result, not how to do that, and PQ is not installed in my computer.
    Reply With QuoteRegister To Reply
  7. 06-25-2022, 02:16 AM #7
    AliGW
    AliGW is online now
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,383

    Re: Survey responses in multiple columns should aligned in single column against username

    PQ is included in Excel 2016 - it is on the Data ribbon (Get & Transform).

    If you set it up, your colleagues don't need to manipulate PQ at all. I am really not clear on your objection to it.

    I will leave it to others to offer altearnative solutions.
    Reply With QuoteRegister To Reply
  8. 06-26-2022, 04:19 AM #8
    farhanahamed
    farhanahamed is offline
    Registered User
    Join Date
    02-22-2013
    Location
    bangalore
    MS-Off Ver
    Excel 2016
    Posts
    35

    Re: Survey responses in multiple columns should aligned in single column against username

    Thanks Aligw. Using Power Query is good option, it worked for me.
    Reply With QuoteRegister To Reply
  9. 06-26-2022, 05:01 AM #9
    AliGW
    AliGW is online now
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,383

    Re: Survey responses in multiple columns should aligned in single column against username

    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.

    Also, if you have not already done so, you may not be aware that you can thank those who have helped you by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of all those who offered help.
    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. Pivot Table Survey Data Multiple Questions, 5 Responses, Calculated Feilds
    By MysticGenius in forum Excel Charting & Pivots
    Replies: 20
    Last Post: 07-17-2019, 11:34 PM
  2. Need to move multiple responses in single cell to single response in multiple cells
    By BBExcelusr in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 02-21-2014, 05:33 PM
  3. Pivot Table Survey Data Multiple Questions, 5 Responses
    By mydragonstalents in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 11-20-2013, 06:15 AM
  4. numbesr in single cell to digit multiple cells but aligned ones,tens...
    By wfsai in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-02-2012, 10:42 AM
  5. Dealing with single and multiple responses
    By mfubib in forum Excel General
    Replies: 2
    Last Post: 12-09-2010, 07:57 PM
  6. Tracking multiple Survey Responses with Countif
    By BILL KAY in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-30-2008, 10:58 AM
  7. Counting survey responses
    By Working with survey responses in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-12-2005, 09:06 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1