Thread: How to change data from two rows into 2 columns
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Katherine Katherine is offline
external usenet poster
  
Posts: 16
Default How to change data from two rows into 2 columns
Hi I have the following Data

Staff A Cellular Phone xxxx
Staff A Residential Phone xxxx
Staff B Cellular Phone xxxx
Staff B Residential Phone xxxx

How do I change the rows into columns i.e. Celluar Phone for one column and
Residential phone for the other with the correct telephone number.
Reply With QuoteReply With Quote