title: Convert columns into rows respectively in SQL
body: <p>I really have been looking hard for an answer and still can't find one. Please help!</p>
  
  <p>I have a workbook in excel that I would like to manipulate in Access using VBA or SQL.</p>
  
  <p>The current problem I am facing is I have a spreadsheet where each row is a based on one invoice (2500 rows). Each row consists of  "Invoice Number" "PO Number" "Invoice Date" "Invoice Total". We can call that Invoice Data</p>
  
  <p>Then in that row there are cells based on Line Item information, "Item Number" "Item Cost" "Item Quantity". Line Item Data</p>
  
  <p>And the Line Item Data repeats until each line item from the invoices covered (i.e. if 70 line items, there would be 70 different line item data and a bunchhhhh of columns)</p>
  
  <p>I need a way to make it so each row is based on the Line Item information, instead of the invoice information, while each row still keeps the items respective invoice info ( "Invoice Number" "PO Number" "Invoice Date" "Invoice Total").</p>
  
  <p>Also the code needs to be simple enough that I don't need to tell it to copy line 1 item data then line 2 item data, etc until line item 70 data. (Maybe it can understand every 3 columns is a new item and the row it is on has its invoice info that it will take). It also can't stop when there are blank columns on row 1 because there could be 50 items in row 30. (invoice 1 had 3 line items, invoice 30 had 50 line items)</p>
  
  <p>I will continue to look to find an answer and if I do find one I will post it here.. Thank you for your help in advance!</p>