title: Change Data layout in excel
body: <p>Hi guys I have excel data taken from vendor in undesired format.
  I want to change the format of layout so that it would be easier for me to ingest this data to database such as (Postgre / Mysql)</p>
  <p>The image below would be best way to describe the situation:</p>
  <p><a href="https://i.stack.imgur.com/lldJU.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/lldJU.png" alt="enter image description here" /></a></p>
  <p>There are thousands of file in this format as one file contain informations of only sales in one date. Is there a better or fast way to convert this data? or creating vba is the only way? Anyone ever deal with this sample of data can kindly give a hint of vba code?</p>
  <p>Thank you</p>