Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Changing Rows to Columns
irst of all, I know there is a way to do so using paste specialtranspose. But it doesn't work for my case.
Ok here's part of my worksheet : There are around 100+ entries of the same format. What I want to do is change all of the rows into columns like this : Where only the Name/Department/Faculty etc only appear once and the respective values go into the respective collumns. Is there a VBA code to do it or can it be done without? Appreciate any help given! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing from Rows to Columns | Excel Discussion (Misc queries) | |||
Changing Rows into Columns | Excel Discussion (Misc queries) | |||
Changing columns into rows | Excel Discussion (Misc queries) | |||
changing rows for columns | Excel Programming | |||
Changing Columns to Rows | Excel Discussion (Misc queries) |