title: Transposing duplicate rows to columns in Excel
body: <p>I've scraped some name data based on URLs and the resultant spreadsheet looks like this:</p>
  
  <p><img src="https://i.imgur.com/DHuEeDF.png" alt="Img1"></p>
  
  <p>As you can see, URLs with more than one name are being turned into multiple rows.</p>
  
  <p>I want to transpose these duplicate URLs into columns, like this:</p>
  
  <p><img src="https://i.imgur.com/QoptX3c.png" alt="Img2"></p>
  
  <p>Does anybody know how I can do this? I've read similar threads that suggest macros, but it seems as if this is not a wholly unusual problem, so I would expect something like Google Refine of Excel itself to have a function or formula that would suffice?</p>
  
  <p>I would appreciate any help or input.</p>