Hi, so for today's last question. This is something I belive is quite easy and probably asked many times, yet since English is not my first language, maybe I use the wrong expressions and can't find the sought code. My goal for the code is 1. delete last 3 rowsform the column. 2. transpose the row to get this effect: 1 2 3 4 and transpose to this 1 2 3 4 Basically to transpose the column data in to rows , with set number of columns in the output table. I belive I should use a loop here but I just cant figure out how. I can easilly do it without VBA but I just wnat to be able to know how to do it in VBA.

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

VBA column to rows table

Thread starter Gokuba
Start date Aug 7, 2018
Tags

column columns to rows transpose vba

Gokuba

New Member

Aug 7, 2018

Hi, so for today's last question.
This is something I belive is quite easy and probably asked many times, yet since English is not my first language, maybe I use the wrong expressions and can't find the sought code.
My goal for the code is
1. delete last 3 rowsform the column.
2. transpose the row to get this effect:

[TABLE="width: 500"]
<tbody>[TR]
[TD]1[/TD]
[/TR]
[TR]
[TD]2[/TD]
[/TR]
[TR]
[TD]3[/TD]
[/TR]
[TR]
[TD]4[/TD]
[/TR]
</tbody>[/TABLE]

and transpose to this

[TABLE="width: 500"]
<tbody>[TR]
[TD]1[/TD]
[TD]2[/TD]
[TD]3[/TD]
[TD]4[/TD]
[/TR]
</tbody>[/TABLE]

Basically to transpose the column data in to rows , with set number of columns in the output table.
I belive I should use a loop here but I just cant figure out how. I can easilly do it without VBA but I just wnat to be able to know how to do it in VBA.