+ Reply to Thread
Results 1 to 2 of 2

Converting an array of data into multiple arrays based on a single column values

  1. #1
    Forum Contributor
    Join Date
    02-13-2013
    Location
    Columbia, SC
    MS-Off Ver
    Excel 2010
    Posts
    217

    Converting an array of data into multiple arrays based on a single column values

    I have columns of data that goes through A:I. Is there a macro to create new columns? It is kind of hard to explain what I want to do, but I'll try. I have columns of data. In column A, I have numbers that start going up. If the number in the column A row n+1 is greater than n, id like to take all the data below that point and put it in K:S (leaving a blank column). Then perform same operation on column K. Note that data in the columns next to the column being sampled needs to move with that column.

    I doubt this makes sense, but worth a shot to ask.

  2. #2
    Forum Expert JLGWhiz's Avatar
    Join Date
    02-20-2011
    Location
    Florida, USA
    MS-Off Ver
    Windows 10, Excel 2013
    Posts
    2,070

    Re: Converting an array of data into multiple arrays based on a single column values

    If you are looking for a one time procedure to reorganize your current data, then assuming you want to only have data through row 100.

    Please Login or Register  to view this content.
    This will result in 10x100 block sections of data separated by an empty column with the last block containg any amount less than 100 rows.
    Last edited by JLGWhiz; 11-16-2018 at 01:17 PM.
    Any code provided by me should be tested on a copy or a mock up of your original data before applying it to the original. Some events in VBA cannot be reversed with the undo facility in Excel. If your original post is satisfied, please mark the thread as "Solved". To upload a file, see the banner at top of this page.
    Just when I think I am smart, I learn something new!

+ 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. Replies: 2
    Last Post: 12-04-2013, 09:45 PM
  2. Replies: 3
    Last Post: 01-22-2013, 03:22 PM
  3. [SOLVED] How would one create a single list of #'s (array) from multiple lists (arrays)?
    By Rstrand in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 01-08-2013, 07:32 PM
  4. MACRO to transform single column to multiple columns, based in dynamic values
    By gaqueiroz in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-08-2012, 01:54 PM
  5. Converting single column into multiple rows with irregular data
    By longhornpete in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-18-2012, 10:27 AM
  6. Replies: 5
    Last Post: 03-10-2009, 11:02 PM
  7. Converting an array of data into a single column
    By Raj in forum Excel General
    Replies: 0
    Last Post: 08-15-2006, 04:25 PM
  8. [SOLVED] Creating a single vertical array from multiple column arrays
    By Bryan in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-10-2005, 03:15 PM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1