Unable to get the formula correct to merge my data from multiple columns into one column.

NortheasternPS

Andrée Starå

Hi @NortheasternPS

I hope you're well and safe!

How do you want it to merge?

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

NortheasternPS

I would like it to merge to look like this. I hope this is what you mean.

Monday: 2pm, 3pm, 4pm, 5pm, 6pm, 7pm, 8pm,

Tuesday: 9am, 10am, 11am, 12pm, 1pm, 2pm

Wednesday: 2pm, 3pm, 5pm, 6pm, 7pm, 8pm

Thursday: 9am, 10am, 11am, 12pm, 1pm, 2pm,

Friday: 9am, 10am, 11am, 12pm, 2pm,

I would then copy this availability and put it in the body of am email.

Paul Newcome

Try this:

=IF(Sunday@row <> "None of the above", "Sunday: " + SUBSTITUTE(Sunday@row, CHAR(10), ", ") + CHAR(10), "") + IF(Monday@row <> "None of the above", "Monday: " + SUBSTITUTE(Monday@row, CHAR(10), ", ") + CHAR(10), "") + IF(Tuesday@row <> "None of the above", "Tuesday: " + SUBSTITUTE(Tuesday@row, CHAR(10), ", ") + CHAR(10), "") + IF(Wednesday@row <> "None of the above", "Wednesday: " + SUBSTITUTE(Wednesday@row, CHAR(10), ", ") + CHAR(10), "") + IF(Thursday@row <> "None of the above", "Thursday: " + SUBSTITUTE(Thursday@row, CHAR(10), ", ") + CHAR(10), "") + IF(Friday@row <> "None of the above", "Friday: " + SUBSTITUTE(Friday@row, CHAR(10), ", ") + CHAR(10), "") + IF(Saturday@row <> "None of the above", "Saturday: " + SUBSTITUTE(Saturday@row, CHAR(10), ", ") + CHAR(10), "")

NortheasternPS

Thank you! I will try this. Much appreciated.

Paul Newcome

Happy to help. 👍️