Hi,

Select the data then

edit|Copy

then select a cell in row 1 outside the data range you just copied

Edit|Paste Special - select transpose

OK

Mike

"bollard" wrote:

I have a list of food items in Column A. I want to convert these so that they
become entries in Row 1 instead. Can anyone advise how to do this?

Thanks.

Keith