I am trying to manipulate a file to add a column, based on a linear value. As of right now, I'm not sure what the best method would be. I could import and manipulate through Access, or keep the file in it's Excel form and add the field. I'm thinking, based on the complexity, something like Access will be needed. See my attached example.
What I need to do is create a column that will add the appropriate location#. So in my sample, I have 4 lines worth of detail (per store), then a summary line. What I want to do is take the summary line (Totals for Store #) and apply that "number" to the items above it (then remove the total line, as it does me nothing in the grand scheme of things). Basically, I only need to to establish what location the detail pertains to. Please see my second attachment to show what I'm looking to accomplish. I'm not trying to remove the lines right at this stage (although it could happen here). I'm simply trying to apply the location detail to each record pertaining to that location.
I'm not sure if Excel can handle that function, hence why I introduced Access as an option. I'm open either way.
I am not a mainstream programmer. I sometimes can "make things work" but that's my scope. I would appreciate any and all insight into this issue. I have looked around, but unfortunately given my detail, it's hard to find something that is in line with what I'm trying to do. Any direction would be MOST appreciated.