Results 1 to 7 of 7

Thread: [RESOLVED] Help with Transpose

Threaded View

  1. Mar 14th, 2023, 09:36 AM #1
    MartinLiss
    MartinLiss is offline

    Thread Starter
    Former Admin/Moderator MartinLiss's Avatar
    Join Date
    Sep 1999
    Location
    San Jose, CA
    Posts
    33,431

    Resolved [RESOLVED] Help with Transpose

    I have an array called "Result" that contains a variable number of columns and 252 rows. Assuming there are 2 columns I'd like to use Transpose to place the array into column CJ where the array columns are are concatenated. For example if Result(0,0) is 66 and Result(1,0) = 52 then CJ1 should be 6652. The concatenation of Result(0,1) is 66 and Result(1,1) should follow that, etc.
    Last edited by MartinLiss; Mar 14th, 2023 at 09:48 AM.
    Tips, Examples & Tutorials:
    A valuable forum tool • Generate unique TreeView keys • TreeView with "open" and "closed folder" icons • Time code using GetTickCount • How to trap the Tab key • Scroll a form • NumberBox ActiveX control • Color a ListView row • An InputBox form • How to use SaveSetting and GetSetting • A program registration scheme • Spellcheck a Textbox • Resize controls • Open Windows Explorer at Last Visited Path • A Blackjack Game • Count lines of code • Private Message Viewer • Copy/Paste VB Code • Paste VB Code Add-In • Insert Procedure Names Add-In • A calculator for the game of Spider • My review of REALbasic 2008 • VB6 Debug Tutorial • Picture/Video Viewer • VBF Photo Contest Winners


    2009 - 2016
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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


Click Here to Expand Forum to Full Width