title: vba to sort the data into matrix form
body: <p><a href="https://i.stack.imgur.com/fYLYC.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/fYLYC.png" alt="enter image description here"></a></p>
  
  <p>I have some data, for the first column date, it contains two dates.</p>
  
  <p>Then I have the fund code and the categories, the last column is the categories value. </p>
  
  <p>How shall I put them into matrix format, for example, the categories is horizontal and the value correspond to the fund name and categories and the date.</p>