title: I have data in columns and would like to convert it to rows. Specificall Manufacturer and Manufacturer PN in columns to rows
body: <p>I have data in columns and would like to convert to rows like below. Specifically I have Manufacture and Manufacture PN and alternates the I want to convert to rows. </p>
  
  <p>Columns
  527510 data 1   data 1.1  data 2   data 2.1
  527520 data 1   data 1.1  data 2   data 2.1 data 3   data 3.1</p>
  
  <p>Convert to rows
  527510  data 1   data 1.1
  527510  data 2   data 2.1
  527520  data 1   data 1.1
  527520  data 2   data 2.1
  527520  data 3   data 3.1</p>
  
  <p>Much appreciated 
  T. Miller</p>