Results 1 to 8 of 8

Transpose 2 dimensional to 1 dimensional (single column)

Threaded View

  1. #1
    Registered User
    Join Date
    04-17-2021
    Location
    Dong Nai
    MS-Off Ver
    365
    Posts
    2

    Transpose 2 dimensional to 1 dimensional (single column)

    I have a (probably) simple problem but could not solve it for the life of me. I need to copy 2-dimensional array from one sheet into a single column on another sheet.

    Example:

    Sheet1, data is in a range C2:N225

    needs to be copied (transposed) onto

    Sheet2, in a range D2:D2680

    > First row of the array (Sheet1!C2:N2) goes into Sheet2!D2:D14
    > Second row (Sheet1!C3:N3) goes into Sheet2!D15:D27
    > ... and so forth

    Many thanks!
    Attached Files Attached Files
    Last edited by tran780; 04-17-2021 at 10:19 PM. Reason: My question has answers

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Convert 2 dimensional array to 1 dimensional
    By jaryszek in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-19-2018, 05:20 AM
  2. Replies: 2
    Last Post: 01-02-2015, 04:24 PM
  3. [SOLVED] transpose two-dimensional array to single column
    By ajan in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 04-15-2014, 03:32 PM
  4. multi-dimensional array to single column
    By pcm2004 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-13-2011, 06:50 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. Selecting a single column of a multi-dimensional array
    By hmatharo in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-21-2008, 11:10 PM
  7. Replies: 13
    Last Post: 07-19-2006, 12:35 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