Results 1 to 11 of 11

Populate 2-column data to multiple columns based on one condition

Threaded View

hcyeap Populate 2-column data to... 12-20-2013, 11:44 AM
Fotis1991 Re: Populate 2-column data to... 12-20-2013, 11:50 AM
ChemistB Re: Populate 2-column data to... 12-20-2013, 11:52 AM
azumi Re: Populate 2-column data to... 12-20-2013, 11:52 AM
hcyeap Re: Populate 2-column data to... 12-20-2013, 12:40 PM
hcyeap Populate data to multiple... 12-20-2013, 01:37 PM
Richard Buttrey Re: Populate data to multiple... 12-20-2013, 01:48 PM
hcyeap Re: Populate 2-column data to... 12-20-2013, 10:37 PM
hcyeap Re: Populate 2-column data to... 12-21-2013, 01:57 AM
hcyeap Re: Populate 2-column data to... 12-21-2013, 09:11 AM
ChemistB Re: Populate 2-column data to... 12-26-2013, 10:42 AM
  1. #1
    Forum Contributor
    Join Date
    11-21-2013
    Location
    KL
    MS-Off Ver
    Excel 2010
    Posts
    168

    Populate 2-column data to multiple columns based on one condition

    Hi,

    I have a 2-column data, one is name another one is leader.

    I wanted to populate the data into multiple columns ie the column header as each leader's name

    I tried with index-macth combination, but it will duplicate the names.

    Got stuck for hours.... appreciate any kind of assistance.

    Thank yo very much.

    HC
    Attached Files Attached Files
    Last edited by Richard Buttrey; 12-20-2013 at 01:43 PM. Reason: additional Q

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. VBA to separate data into multiple columns based on certain condition
    By VBADumb in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-25-2013, 09:41 PM
  2. Populate Output sheet based on input data and lookup condition
    By Cool\m/ in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 07-10-2013, 04:45 AM
  3. Auto Populate Two Columns Based On Data Entered Into Another Column
    By aleenah in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-12-2013, 08:37 PM
  4. Count no of data present in a specified column based on multiple condition
    By SubhasreeM in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-27-2012, 06:24 AM
  5. Select worksheet based on condition & populate cell based on condition
    By beth1069 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-19-2011, 01:27 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