+ Reply to Thread
Results 1 to 4 of 4

Map column of numbers to a matrix

  1. 04-14-2021, 09:28 AM #1
    Nick Riviera
    Nick Riviera is offline
    Registered User
    Join Date
    09-11-2019
    Location
    Villahermosa, Mexic
    MS-Off Ver
    2016
    Posts
    10

    Map column of numbers to a matrix

    Hello

    How do i transpose column A to ..image below:
    Thank you very much

    [1]04-14-2021.jpg
    Reply With QuoteRegister To Reply
  2. 04-14-2021, 09:43 AM #2
    Pepe Le Mokko
    Pepe Le Mokko is offline
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,447

    Re: Tarnspose numbers

    Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file.
    Reply With QuoteRegister To Reply
  3. 04-14-2021, 10:47 AM #3
    Nick Riviera
    Nick Riviera is offline
    Registered User
    Join Date
    09-11-2019
    Location
    Villahermosa, Mexic
    MS-Off Ver
    2016
    Posts
    10

    Re: Tarnspose numbers

    sorry
    attached file
    thanks



    Quote Originally Posted by Pepe Le Mokko View Post
    Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  4. 04-19-2021, 06:39 PM #4
    JeteMc
    JeteMc is offline
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,562

    Re: Map column of numbers to a matrix

    Try pasting the following into cell C2, then dragging the fill handle over to cell F2 and then, while C2:F2 are still selected, drag the fill handle down to cell F7:
    Formula: copy to clipboard 
    Please Login or Register  to view this content.

    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
    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. I need a formula or matrix to provide me with 6 numbers per row that come up in 1 column t
    By Aceman53 in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 01-27-2020, 05:57 AM
  2. [SOLVED] Generate random lines 3 numbers limit per line and 3 per column The matrix below 5x5
    By jorel in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-24-2016, 07:18 PM
  3. Subtract all numbers of a column by another column, return a matrix of subtracted values
    By eliasbyvasoula in forum Excel General
    Replies: 1
    Last Post: 12-28-2015, 08:43 AM
  4. [SOLVED] Matrix: Identify cell content in column for a row if matrix content true
    By deuy2014 in forum Excel General
    Replies: 10
    Last Post: 03-27-2014, 06:05 PM
  5. Matrix: Identify cell content in column for a row if matrix content true
    By deuy2014 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-21-2014, 11:52 AM
  6. Plotting a named multi-column matrix array column by column without naming columns
    By luv2glyd in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 01-14-2014, 06:35 PM
  7. Sum of numbers in a matrix...
    By Zadig Galbaras in forum Excel General
    Replies: 7
    Last Post: 01-04-2006, 08:50 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