With data in column A, pick some cells and enter:
Then copy both across and down.
I hope this helps you.
VBA Code :
Dim ws as Worksheet
Dim pwd ...READ MORE
Let's say I have the following figures ...READ MORE
Private Scan As Integer
Private Sub CommandButton1_Click() ...READ MORE
I paste the values with a keyboard ...READ MORE
I having a Excel sheet with 1 ...READ MORE
I have a reasonably large matrix that I need to transpose.
Assume, for example, that my matrix is
a b c d e f
g h ...READ MORE
select A1:J1 in worksheet B and enter:
=TRANSPOSE('worksheet ...READ MORE
Due to the amount of your data, ...READ MORE
Put a $ symbol in front of ...READ MORE
All you have to do is copy ...READ MORE
At least 1 upper-case and 1 lower-case letter
Minimum 8 characters and Maximum 50 characters
Already have an account? Sign in.