Recent content by scrubby94

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

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

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

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.

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

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 a young professional in the material handling industry and I am learning to manage big data and all of the programs associated with this field. Currently I am attempting to learn VBA and am here for guidance and assistance as well as to talk with fellow people like me. Hi!