The ampersand symbol is a quick and easy way to combine data in Excel. To explain this method to you, I have created sample data in Excel with the names of some persons (refer to the above screenshot) ...

Select the cell(s) where you want the text to appear vertically. Go to the Home tab in the top ribbon. In the Alignment group, click the Orientation drop-down arrow. Choose Vertical Text from the list ...

If you've used Excel's Merge And Center tool for a long time (like I had), you could be forgiven for thinking there's no better alternative (like I did). Well, let me introduce you to Center Across ...