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