Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

new to vb

scuddersscudders Member Posts: 1
I am very new to visual basic and was trying to transpose information. I have a list of companies on the share market with about 10 figures and ratios for each(over 2000 figures total). All names and figures are in column A in excel, but I need to transpose these figures to rows. There must be new column headings for each figure for example like this:
Raw data looks like this:
Company A
12
10
11
company B
13
14
1
Transposed data like this:
Company A 12 10 11
Company B 13 14 11 etc
There also need to be a macro to copy the raw data first to preseverve it and a button to make the program start.
I do not know how to separate each company and its data from the list and how to stop the program as i have tried to use the method of findong the empty cell to find the finish but there are many empty cells throughout the raw data, how do i make it ignore this?

Comments

  • Shawn CarterShawn Carter Member Posts: 0

    _ [ http://forcoder.org ] free video tutorials and ebooks about [ C# PHP Assembly Ruby Swift Visual Basic Objective-C Perl C PL/SQL Java Python MATLAB R JavaScript Go C++ Visual Basic .NET Scratch Delphi Apex Ada Bash Rust COBOL Lisp Logo Kotlin Julia Crystal Scheme Hack VBScript Alice LabVIEW ML Fortran Transact-SQL ABAP Prolog Clojure Lua Scala FoxPro F# D Awk SAS Erlang Dart ] _

Sign In or Register to comment.