+ Reply to Thread
Results 1 to 2 of 2

Convert 2 dimensional array to 1 dimensional

Hybrid View

  1. 06-19-2018, 05:14 AM #1
    jaryszek
    jaryszek is offline
    Forum Contributor
    Join Date
    01-16-2014
    Location
    Poland
    MS-Off Ver
    Excel 2016-365
    Posts
    2,946

    Convert 2 dimensional array to 1 dimensional

    Hi,

    Hi i have array like here:

    Screenshot_11.png

    ArrayNames2 = Range("A4:c4").Value
    and i want to have output like here:

    Screenshot_12.png

    How can i achevie this?

    Best,
    Jacek
    Reply With QuoteRegister To Reply
  2. 06-19-2018, 05:20 AM #2
    jaryszek
    jaryszek is offline
    Forum Contributor
    Join Date
    01-16-2014
    Location
    Poland
    MS-Off Ver
    Excel 2016-365
    Posts
    2,946

    Re: Convert 2 dimensional array to 1 dimensional

    Ok problem solved:

    arraynames3 = Application.WorksheetFunction.Index(ArrayNames2, 0, 0)
    Best,
    Jacek
    Reply With QuoteRegister To Reply
+ Reply to Thread
« 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. Help converting one-dimensional array to multi-dimensional array
    By puzzlelover22 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-13-2016, 06:48 AM
  2. Parse Data from one dimensional array into a 2 dimensional array.
    By JapanDave in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-30-2016, 07:29 AM
  3. [SOLVED] Convert one dimensional array into two dimensional array
    By mohammed sabr in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 04-26-2015, 10:34 AM
  4. [SOLVED] Convert two dimensional row to column data to a hard-coded array
    By evancharles in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 06-07-2013, 03:15 PM
  5. Creating a 2-dimensional array from a 1-dimensional list
    By guywithcamera in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-27-2008, 06:34 PM
  6. How do I convert a row of cells into a two-dimensional array?
    By Glenn@stress in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 10-10-2005, 03:05 PM
  7. Create One-Dimensional Array from Two-Dimensional Array
    By Stratuser in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-23-2005, 05:06 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