Excel code to represent data from row wise to column wise

Hi,

I am having data in two columns as below

column1 column2
top level sub level
a a1
a a2
a a3
a a4
b b1
b b2
b b3
b b4
b b5

now i need the data to get represented column wise as below. Since the data is huge VBA code would be appropriate.

column1 column2 column3 column4 column5 coumn6
Top level Sub level Sub level Sub level Sub level Sub level
a a1 a2 a3 a4
b b1 b2 b3 b4 b5


regards
Sreejesh

Sample file attached..

Hi,

Here is some code that will transpose your 2 columns (not including the headings - if you need the headings done too, let me know and I'll amend my code for you).

Try placing a button (called "CommandButton1") on the worksheet that you are referring to in your original post, and place this code in the click event for that button (make sure you correctly specify the first and last rows that you want transposed):

Please Login or Register  to view this content.

This should do what you're asking (hopefully). If not let me know what isn't right about it.

Once you have completed the transposition, you can delete the button and this code, as it won't be needed any longer.

Hope this helps

I would be mighty impressed if you could come up with a formula solution to this one

Thanks very much.. the code the working perfect...

No problems!

Don't forget to add some reputation...

Glad to help