Layouts

Hi Peter,
Thank you for your forum question.

To change the layout of a list from horizontal to vertical you highlight a column or an entire list. You then copy the selected cells.

You cannot paste the new layout over the old layout. So he best thing to do is to go to a new sheet. Do a right click in the cell that you want to paste and choose Paste Special... and in the Pate Special dialogue box click the check box that states 'Transpose' and then click OK. And that should have changed the layout.

I have attached a word document with the steps. I hope it is clear but if you have anything to add or it is not what you intended to do then please let me know and we will find a solution together.

I hope this helps solve your issue.

Many thanks

Ron