+ Reply to Thread
Results 1 to 5 of 5

How to multiple line based on column?

  1. #1
    Registered User
    Join Date
    07-28-2020
    Location
    Israel
    MS-Off Ver
    office 365 pro plus
    Posts
    2

    How to multiple line based on column?

    Hello,
    I have this table, I would like that each name will get line for each question. See example in the sheet.
    Any idea how to do that easily?
    Thanks
    M
    Attached Files Attached Files

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: How to multiple line based on column?

    I think you are going to need to walk us through what you are doing here.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    08-06-2020
    Location
    Canada
    MS-Off Ver
    MS Office 2007
    Posts
    8

    Re: How to multiple line based on column?

    I wrote a UDF just for this sort of task

    RETURNELEMENTS

    If your source data is in A2 for example

    Then =returnelements(A2,char(10), x ) where x is the row to extract.

  4. #4
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,810

    Re: How to multiple line based on column?

    You have posted in an Access Forum. Is this an Access or Excel issue.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  5. #5
    Registered User
    Join Date
    10-06-2020
    Location
    Cologne, Germany
    MS-Off Ver
    Microsoft Office 2020
    Posts
    16

    Re: How to multiple line based on column?

    Do you need changes in Excel or Access document?

+ 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. [SOLVED] Line up values from one column based on value from another column
    By Paulius03 in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 04-11-2020, 09:44 AM
  2. [SOLVED] Copy a line from one spreadheet tab to another based on criteria of column
    By jdwh in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-31-2018, 04:59 AM
  3. Replies: 1
    Last Post: 03-10-2014, 04:09 PM
  4. Multiple column data into one line ?
    By kjk555 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-02-2013, 01:42 PM
  5. Combining multiple line items into one line item based on column.
    By mguz018 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-20-2012, 07:22 PM
  6. Insert Line Every Other Row w/Multiple Formulas based on Line Above
    By xyshel in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-23-2011, 11:09 AM
  7. Replies: 2
    Last Post: 02-28-2006, 12:15 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1