Results 1 to 20 of 20

Generate array from multiple rows

Threaded View

  1. 05-23-2017, 06:13 PM #1
    augr
    augr is offline
    Registered User
    Join Date
    06-09-2014
    Location
    Hawaii
    MS-Off Ver
    Office 365
    Posts
    75

    Generate array from multiple rows

    Hi,

    I have a large file with ~800K rows and I'm trying to generate an array from Column C from the names in Column B or ID in Column A (grouping Column A or B into 1 row and creating an array from Column C in the same row).

    Please see attached sample data and output as I'm having a hard time explaining.

    Thanks for your help!
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« 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. [SOLVED] generate multiple rows with vba
    By ROHAN999 in forum Excel Programming / VBA / Macros
    Replies: 54
    Last Post: 10-12-2016, 07:54 PM
  2. generate rows of 50 numbers watching the array at the boundary 5 numbers per line 5 per c
    By jorel in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-07-2016, 10:34 PM
  3. How can I generate a new rows for a list every n steps and then generate summary sheet?
    By AntiPivotTable in forum Excel General
    Replies: 1
    Last Post: 02-16-2016, 07:51 PM
  4. Index Match Multiple Results - Not able to generate a value using array entry
    By jrr123 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 04-23-2015, 10:02 AM
  5. [SOLVED] Generate multiple invoices fetching data from rows of a sheet
    By devang.vakharia in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 09-12-2013, 08:14 AM
  6. Generate List of Matching Rows from multiple tabs
    By xenocide8d in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 03-02-2010, 12:52 AM
  7. generate multiple rows based on cell value
    By Theresa in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 05-25-2005, 06:21 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1