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.
  • Go back-and-forth until satisfied
    Rate the answer you receive.
Ask Rafael Martins Your Own Question
Rafael Martins
Rafael Martins, Computer Software Engineer
Category: Programming
Satisfied Customers: 446
Experience:  Desktop, Mobile and Web Developer. 7+ years of experience. Creative solutions provider.
16777065
Type Your Programming Question Here...
Rafael Martins is online now

I need to concatenate values in a column, based on a unique

Customer Question

Hello, I need to concatenate values in a column, based on a unique identifier, so e.g. column A has 123, 123, 123, 123, 123 and column B has 5 different values and I need to create a concatenation with | separator. However, the next unique number in column A might have 8 rows or 2 etc
JA: Is there a specific language you're coding in?
Customer: I am not coding, looking at formulas
JA: What's your objective? How can we solve this for you?
Customer: I would like to know if this can be done with a formula or requires coding
JA: Anything else you want the programmer to know before I connect you?
Customer: no, that's it
Submitted: 16 days ago.
Category: Programming
Expert:  NILESH PANCHAL replied 16 days ago.

Hello and Welcome to JustAnswer, an independent Question and Answer site. My name is ***** ***** I will be happy to assist you today!

Kindly share your excel file with sample data and let me know your requirements in details so we can work on it.

Customer: replied 16 days ago.
this is what I am trying to achieve
Customer: replied 16 days ago.
this is what I am trying to achieve, thanks for responding
Expert:  NILESH PANCHAL replied 16 days ago.

Kindly give me some time to review the details and I will get back to you.

Customer: replied 16 days ago.
ok