muhammad susanto
Well-known Member
- Joined
- Jan 8, 2013
- Messages
- 2,077
- Office Version
- 365
- 2021
- Platform
- Windows
hi guys..
could you help me, how to figure out this problem using vba code (transpose multiple column into one column):
sample data (in col.a)
<tbody>
</tbody>
after macro :
<tbody>
</tbody>
any assistance, will be appreciated...
m.susanto
could you help me, how to figure out this problem using vba code (transpose multiple column into one column):
sample data (in col.a)
COL.A | B | C | D | E |
ACTIVE | PT BANK | JOHN MAC OBAMA | 2014.12.00025 | MEDAN STREET # 10 |
ACTIVE | PT AGUNG | LEE DONALD | 2014.12.00965 | SAHANA STREET 8 |
etc.. |
<tbody>
</tbody>
after macro :
col.G |
ACTIVE |
PT BANK |
JOHN MAC OBAMA |
2014.12.00025 |
MEDAN STREET # 10 |
(BLANK ROW/SPACE) |
PT AGUNG |
LEE DONALD |
2014.12.00965 |
SAHANA STREET 8 |
etc... |
<tbody>
</tbody>
any assistance, will be appreciated...
m.susanto