Hi,

I am New to excel programing in VB,
I want to know the code how to change the row to colume and colume to
row

for eg if i have : abc 1 2 3
xyz 2 3 5
hgf 3 4 3

and i have a button call CHANGE

when i click on the button CHANGE

the data should be viewed as below


abc 1
abc 2
abc 3

xyz 2
xyz 3
xyz 5

hgf 3
hgf 4
hgf 3

can anyone let me know the code

and can i can i know where i lean online for programing in VB

Thanks in advance

Regards