akhendre88
Board Regular
- Joined
- Sep 17, 2015
- Messages
- 76
Hello All,
Can we transpose the data vertically. I have some data in below format.
<tbody>
</tbody>
So is there any way so that I align the data in 'Roles' column like
<tbody>
</tbody>
I was trying this,
but the output was only first value i.e. READ.
Please suggest.
Thank you
Can we transpose the data vertically. I have some data in below format.
Emp Id | Access Id | Roles | ||
A001 | abcd | READ | WRITE | DELETE |
<tbody>
</tbody>
So is there any way so that I align the data in 'Roles' column like
Emp Id | Access Id | Roles |
A001 | abcd | READ |
WRITE | ||
DELETE |
<tbody>
</tbody>
I was trying this,
Code:
sht.Range("C" & i) = WorksheetFunction.Transpose(.Range("C" & i))sht.Range("C" & i) = WorksheetFunction.Transpose(.Range("C" & i))
Please suggest.
Thank you