We help IT Professionals succeed at work.
Get Started

File Manipulation

355 Views
Last Modified: 2012-05-12
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.

Thank you again for your time.
SAMPLE.xls
SAMPLE-OUTCOME.xls
Comment
Watch Question
Finance Analyst
CERTIFIED EXPERT
Commented:
This problem has been solved!
Unlock 1 Answer and 11 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE