title: How to merge duplicate rows in Excel based on column A and keep data
body: <p>I have a .csv with a table that looks like this:</p>
  <p><a href="https://i.stack.imgur.com/OCQ6E.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/OCQ6E.png" alt="enter image description here" /></a></p>
  <p>and I would like to merge the values in the rows that are duplicate
  based on column A.<br />
  The end result to be like this:</p>
  <p><a href="https://i.stack.imgur.com/D3CHl.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/D3CHl.png" alt="enter image description here" /></a></p>
  <p>I would appreciate a bit of help please as I've tried with PivotTable in Excel  but I must be doing something wrong<br />
  as it messes up the data.</p>