I've created a report in Access that produces company name and email addresses, with blank company name when multiple emails are present. I can't figure out how I can merge and center the cells in the company name column. Is it possible? With a report or a spreadsheet output?
Acme Inc email1@email.com Vinny's company emailxyz@email.com email999@email.com Great Big Mega company emailxxx@email.com info@gmail.com support@hotmail.com
I want it to look like this:
Can this be done with conditional formatting in access or Excel?