VBA Script - Transposing en masse

[scrubby94]

I am very (read: 1 day into learning) new to VBA and am attempting to create a script that can transpose data seperated by a specific field [filename] so that the data is put into a vertical format. Once I am able to I will update with the stackoverflow thread I created explaining the issue and I am updating this post with images showing the issue as well. Thanks for viewing

 

[Ranman256]

you would NOT use script.
you would run an update query that would transpose the fields.
and
veritcal format ONLY applies to forms. This has no affect on tables.

 

[scrubby94]

you would NOT use script.
you would run an update query that would transpose the fields.
and
veritcal format ONLY applies to forms. This has no affect on tables.

I apologize I should have specified that I am working from within excel and not access.

 

[Ranman256]

you want to modify in excel, using excel tools.
just record a macro to do the formatting.
then you have your macro.

 

[scrubby94]

I was under the impression that this was within the Excel section. The only problem I run into with macros is that the amount of rows and columns taken up can vary so much that a macro does not work universally.

 

[Ranman256]

rows & columns are irrelevant. you are transposing the columns , right?
or do you want to transpose 1 data record?

will it be the same field always? or will you change fields to be transposed?

 

[scrubby94]

Yes, it is the columns that I want transposed. The columns are set up in a way that there are not always the same number of columns per data set. If you look at these images I've posted you'll see what I want to do.

imgur.com/On05AVK
imgur.com/hEOFupb

 

[scrubby94]

My problem has been solved as the people on stackoverflow found an answer. Thank you though!

stackoverflow.com/questions/32588213/i-need-to-create-a-vba-script-or-macro-that-can-transpose-and-format-data-all-at?answertab=active#tab-top

 

[Brianwarnock]

Thanks for coming back, so many people get an answer elsewhere but don't tell us causing us to waste our efforts and of course not passing on the knowledge to others who are searching the forum.

Brian

 

[scrubby94]

Thanks for coming back, so many people get an answer elsewhere but don't tell us causing us to waste our efforts and of course not passing on the knowledge to others who are searching the forum.

Brian

It's the least I could do. Thanks for all of the attempts to help me!