I am having an issue manipulating a flat file. The macro I have right now does everything I need, except for one thing.
I sometimes have values in extended columns, rather than below onto the next row. How can I shift/offset these values to the rows below.
I have 2 grids below, one with an example as it is now and another of what I would like to occur. The values that change will be in RED. The values in RED are sporadic, in terms of which flat file they show up in. I made them red to make it easier to find, they are only red for this example and it is not indicative of any other file set.
Also, I have attached an example excel document with sample data.
Example - Ugly:
Example - Good:
Links to other forums:
Contains link to download data in xlsx: http://www.excelforum.com/exce…value-details-inside.html
Has data in forum table: http://www.mrexcel.com/forum/e…set-shift-move-value.html
Thanks for the help!