+ Reply to Thread
Results 1 to 4 of 4

Populate data in specific way (some for separated columns .. others in one columns)

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

    Populate data in specific way (some for separated columns .. others in one columns)

    Hello everyone
    I have a code that extracts the unique names and in adjacent columns put all the values for that name
    It is working very well but I need some modification
    Please Login or Register  to view this content.
    The code produces header .. I don't need that header or I need the header to be fixed (Names , First, Second, Third, Fourth, The rest)
    The code populates all the values to adjacent columns .. but I need to populate only the first four values and the rest of values to be in just one column)
    I have attached the expected results in the green region in the sheet
    Attached Files Attached Files
    < ----- Please click the little star * next to add reputation if my post helps you
    Visit Forum : From Here

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

    Re: Populate data in specific way (some for separated columns .. others in one columns)

    I have studied the code carefully and could figure it out ..
    Here's the solution for me
    Please Login or Register  to view this content.
    But I welcome any other solution ..
    And if possible to do the task by creating UDF ..UDF for the same result exactly

  3. #3
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,523

    Re: Populate data in specific way (some for separated columns .. others in one columns)

    Please Login or Register  to view this content.

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

    Re: Populate data in specific way (some for separated columns .. others in one columns)

    Thank you very much Mr. Jindon .. you are great and genius
    I like your solutions a lot although it is difficult for me but it is distinguished

+ 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. Userforms - To populate data on a specific sheet and columns
    By paradoxofthecat in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-25-2014, 01:33 PM
  2. [SOLVED] How to transfer data that is separated by a comma, into different columns
    By AGExcel in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-04-2014, 06:54 PM
  3. [SOLVED] macro needed to extract specific columns out of multiple columns with their row data
    By genetist in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 01-07-2014, 12:49 AM
  4. Populate 2 columns with data from a different two columns based on one cell's value
    By ChrisHowk in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-19-2012, 06:01 PM
  5. Replies: 3
    Last Post: 08-18-2010, 08:00 AM
  6. Replies: 1
    Last Post: 09-07-2006, 11:17 PM
  7. Replies: 1
    Last Post: 09-07-2006, 04:28 PM
  8. Replies: 2
    Last Post: 06-30-2006, 04:10 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