i have a table with info that reads something like this.
a b c d
1 3 2 9
i would like to write some vba code to convert the info from the table above into another table and the format look like this
a 1
b 3
c 2
d 9
any ideas?
ta!
the info is in a table that is automatically entered from another application in to the table
so i cant really change the format of that table.
so i guess what i want to change is a query result (i think)!!
Can anyone help.
thisis my problem
i have a table that looks something like this.
a b c d e
1 2 2 5 6
i would like to convert the table to look like this.
a 1
b 2
c 2
d 5
e 6
any ideas as to where i should start?
ta!
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.