Thread: how do I unmerge data in a column and distribute in rows?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike Mike is offline
external usenet poster
  
Posts: 3,101
Default how do I unmerge data in a column and distribute in rows?
I have data from an address base that when cut and pasted gourped or merged
three cells. I would like to unmerge them and distribute the information from
3 cells in a column to three cells in a row. I have 1400 addresses, so doing
this manually is not logical. The "unmerge" command does not do anything.
Reply With QuoteReply With Quote