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 an Excel file with two worksheets. I need to add a

Customer Question

I have an Excel file with two worksheets. I need to add a third worksheet that includes in Column A every combination of entries in Column A of each of the first two worksheets separated by a dash character, and then the data from Columns B and C in the first two. I completed the first record on the third worksheet as an example. Given 56 and 52 data records in each worksheet I would be expecting 2,912 (plus header) in the third worksheet. Here is the file. Let me know and thanks!
Submitted: 1 year ago.
Category: Programming
Expert:  tejas_speed replied 1 year ago.
Hi Sir, I would like to assist you on this. I would get back to you shortly on this.
Expert:  tejas_speed replied 1 year ago.
Is this your final worksheet or is it just a demo worksheet?
Customer: replied 1 year ago.
What I sent needs worksheets 1 and 2 merged into worksheet three as described in the question.
Customer: replied 1 year ago.
Are you working on this?