title: SQL Server & SSMS 2012 - Move a value from one column to a new one to ensure only one row
body: <p>This is a problem that has troubled several times in the past an I have always wondered if a solution is possible. </p>
  
  <p>I have a query using several tables one of the values is mobile phone number. 
  I have name, addresss etc.... I also have income information in the table which is used for a summary in Excel. </p>
  
  <p>Where the problem occurs is when a contact has more than one mobile number, as you know this will create extra rows with the majority of the data being duplicate including the income. </p>
  
  <p>Question: is it possible for the query to identify whether the contact has more than one number and if so create a new column with the 2nd mobile number.</p>
  
  <p>Effectively returning the contacts information to one row and creating new columns.</p>
  
  <p>My SQL is intermediate and I cannot think of a solution so thought I would ask. </p>
  
  <p>Many thanks </p>