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:
<tbody>
</tbody>
and transpose to this
<tbody>
</tbody>
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.
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 |
<tbody>
</tbody>
and transpose to this
| 1 | 2 | 3 | 4 |
<tbody>
</tbody>
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.
