Concatenate all the values in cell after each time it is updated

[Jstrom81]

Hi everyone,

I don't think this is possible but thought I would ask here just in case. Here's my problem:

I'm building a repair management system in excel right now where every row represents one repair or one clients repair. One thing we need to constantly update is when and how many times that client is contacted upon completion of the repair. My issue is that right now record each and every time that client is contacted I have separate cells for each time. For example, A1 = March 2, A2 = March 4, A3 = March 10, etc. Is there a way maybe through concatenate function or any other function where I can condense all this info into one cell automatically after I update the cell. For example, if A1 = March 2, then A2 = March 2. as well. If I contact the client again on March 4, then the A1 = March 4, and the A2 now = March2, March 4.

Is this possible? Is there another way to manage this in a more space efficient way?

Please don't hesitate to ask any questions.

Thanks! - Julian

 

[Peter_SSs]

Is there a work around so that you can enter Email back-to-back-to-back for example?

Not that I have found - same for dates.

 

[Jstrom81]

Thanks for your help peter. I'll see if I can find a way to make it work.

 

[Peter_SSs]

Thanks for your help peter. I'll see if I can find a way to make it work.

You're welcome & good luck!

I did manage to get it to add repeats but when it did that it also added repeats to all the other rows when their column B values had not changed, so that was useless.

 

[Jstrom81]

Ah I see, definitely useless! I wouldn't say I'm new to excel but I'm definitely far from a pro or anything. Do you have any suggestions for books or sites that I can start to read on anything and everything excel has to offer? Or would you recommend reading these forums and articles posted on a site like Mr.excel.com? Thanks again!

 

[Peter_SSs]

Most of what I know about Excel I learned here or by Googling - and lots of trial & error. I've really not used books or courses.

 

[Jstrom81]

Yeah everything that I did on this project I'm working on has been just me googling and trial & error. Which is good in a way for me, much better way for me too learn. My problem is that I feel like there functions and formulas that I could be using but I don't know they exist.

 

[Jstrom81]

Just following up on this question. Can you this be achieved in Power Query? Appreciate anyone's help!