title: How to merge cells based on similar values - Excel 2010
body: <p>I have a problem merging cells in excel based on similar values for one column- I would like to keep other columns data - let's view some screenshots and it will be clearer:
  <img src="https://i.stack.imgur.com/PL9zG.png" alt="enter image description here"></p>
  
  <p>This above is the initial state of the Data,
  what I want to achieve is this:</p>
  
  <p><img src="https://i.stack.imgur.com/6Wcak.png" alt="enter image description here"> </p>
  
  <p>I'm sure there is a way to do it with VB or formulas- I need the most simple way possible as this is for a customer and it needs to be easy.</p>
  
  <p>Thank you all in advanced.</p>