Transpose columns to rows with spaces
Select the cells that you want to switch.
Click Copy
Select the upper-left cell of the paste area.
The paste area must be outside the copy area.
On the Edit menu, click Paste Special.
Select the Transpose check box.
"dougaf" wrote:
I have:
name
address
phone#
(empty cell)
name
address
phone#
I need:
name address phone#
name address phone#
I have a large # of items. Any help would be greatly appreciated.
|