Combining text from 2 cells wrapped line for line.

[Keljoe2804]

I've created a log system for changes to my spreadsheet. In one column I have a history of due dates, in the other column I have the date they changed. See below.

This is one Cell
Due Date | Date Changed
4/9/23 2/18/23
3/23/23 3/2/23
12/1/23 3/5/23

What I'd like to do is combine these into one cell
4/9/23 - 2/18/23
3/23/23 - 3/2/23
12/1/23 - 3/5/23

With the common methods of combining cells I get this
4/9/23
3/23/23
12/1/23 - 2/18/23
3/2/23
3/5/23

VBA or formula is fine. I can run VBA on changes.

Thanks

 

[Fluff]

What is your expected outcome?

 

[Keljoe2804]

The first 2 columns below hold the data I want to combine, the last column is an example of the output I'm looking for.

5/1/2023 7/1/2023 6/24/2023

3/1/2023 3/9/2023 3/20/2023

5/1/2023 - 3/1/2023 7/1/2023 - 3/9/2023 6/24/2023 - 3/20/2023

 

[Fluff]

But surely that's what the formula I suggested does.

 

[Keljoe2804]

You are absolutely right, I must've not put it in correctly before. Sorry for the confusion. I'll mark that answer as the solution. Thanks so much!

 

[Fluff]

Glad to help & thanks for the feedback.