VBA Script - Transposing en masse (1 Viewer)

scrubby94 · Sep 16, 2015

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 · Sep 16, 2015

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 · Sep 16, 2015

Ranman256 said:
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 · Sep 16, 2015

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

scrubby94 · Sep 16, 2015

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 · Sep 16, 2015

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 · Sep 16, 2015

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 · Sep 17, 2015

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 · Sep 19, 2015

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 · Sep 21, 2015

Brianwarnock said:
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!

VBA Script - Transposing en masse (1 Viewer)

scrubby94

New member

Ranman256

Well-known member

scrubby94

New member

Ranman256

Well-known member

scrubby94

New member

Ranman256

Well-known member

scrubby94

New member

scrubby94

New member

Brianwarnock

Retired

scrubby94

New member

Similar threads

Users who are viewing this thread