title: Excel : Copy muitple columns to rows based on one column
body: <p>I'm looking for the most efficient approach to transferring information from three columns to one row, right next to each other depending on the company name.
  Consider the following example:</p>
  <ol>
  <li>I have a 226k data list with product details for several customers (around 30-40k).</li>
  <li>One customer can have 2 to 50 products, each with a serial number and a product number. Check out the source data pic.</li>
  </ol>
  <p>Output required: One row per customer will have all the product data, serial number, and product number next to each other.</p>
  <p>Source data</p>
  <p><a href="https://i.stack.imgur.com/unR0o.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/unR0o.png" alt="Source data" /></a></p>
  <p>desired output
  <a href="https://i.stack.imgur.com/wNfLt.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/wNfLt.png" alt="desired output" /></a></p>
  <p>I have never used Macro. Can someone please help me find the best way to deal with this issue?</p>