View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
dougaf dougaf is offline
external usenet poster
 
Posts: 2
Default Transpose columns to rows with spaces

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.