Hi there,
Im trying to create a Macro which can do the following: Start selecting from a1 till blank column and coming down till blank row cell by cell , select the all above values, copy them and paste them by transposing them AFTER tWo blank columns, carry on doing this procedure and pasting the transposed values . Can you please help me with this Macro. Help will be greatly appreciated.
eg;
columnA columnB blank column blank column
<colgroup><col width="64" span="5" style="width: 48pt;"></colgroup><tbody>
</tbody>
<colgroup><col><col></colgroup><tbody>
</tbody>
transpose the data to 2nd blank column .
help will be greatly apppreciated.
Im trying to create a Macro which can do the following: Start selecting from a1 till blank column and coming down till blank row cell by cell , select the all above values, copy them and paste them by transposing them AFTER tWo blank columns, carry on doing this procedure and pasting the transposed values . Can you please help me with this Macro. Help will be greatly appreciated.
eg;
columnA columnB blank column blank column
<colgroup><col width="64" span="5" style="width: 48pt;"></colgroup><tbody>
</tbody>
Demir (Serum) | 16 |
Demir bağlama kapasitesi | 362 |
Glukoz | 109 |
HBA1C | 5,6 |
Demir (Serum) | 41 |
Demir bağlama kapasitesi | 215 |
Ferritin | 56,46 |
Glukoz | 101 |
HBA1C | 5,8 |
<colgroup><col><col></colgroup><tbody>
</tbody>
transpose the data to 2nd blank column .
help will be greatly apppreciated.