How JustAnswer Works:
  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.
Ask ATLPROG Your Own Question
ATLPROG, Computer Software Engineer
Category: Programming
Satisfied Customers: 7677
Experience:  MS in IT.Several years of programming experience in Java C++ C C# Python VB Javascript HTML
Type Your Programming Question Here...
ATLPROG is online now
A new question is answered every 9 seconds

I have a master table that reflects the following labels:

Customer Question

I have a master table that reflects the following labels: UIC, Section, Rank, Last Name, First Name, Type of Ord, Ord #, Amend Ord# ***** Ord #, Start date, End date, # Days, Certified Date, DTS Paid.
JA: What programs and versions are you using?
Customer: What I need is a sheet that is within that reflects some of the data from the Master, specifically Rank, Last Name, First Name, Type of Ord, Start date, End date, and lastly # Days. The problem is the Master reflects individuals name multiple times for different order types or different dates of being on orders. I need the worksheet to have the name listed once, list the start & end date, number of days and a total of days performed to be reflected. Your assistance is much appreciated.
JA: What is your ideal outcome? How can we solve this for you?
Customer: I am using Microsoft Excel 2013, I beleive
JA: Anything else you want the programmer to know before I connect you?
Customer: that should be it
Submitted: 7 months ago.
Category: Programming
Expert:  The-PC-Guy replied 7 months ago.

i think you will need something called a macro.

To be sure, send an example file of the source data and the expected output.