Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
how do you change data from rows to columns
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!- grahamnet
- Thread
- Replies: 7
- Forum: Microsoft: Access Modules (VBA Coding)
-
convert rows of dat in to columns?
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!- grahamnet
- Thread
- Replies: 2
- Forum: Microsoft: Access Tables and Relationships
