title: Split single row into multiple rows based on cell value in excel
body: <p>I have a single row of data in excel. Data is around 5000+ values.</p>
  
  <p>I want to split this single row into multiple rows.Below is the example of same.</p>
  
  <p>My Single row contains data as follows, 1  2  3  4  5  A 1  2  4  5  9  5  9  A  2  1  4  A etc...</p>
  
  <p>I want this single row to be split after every "A" value it reaches. Output below.</p>
  
  <p>1  2  3  4  5  </p>
  
  <p>A  1  2  4  5  9  5  9 </p>
  
  <p>A 2  1  4 </p>
  
  <p>A Etc...</p>
  
  <p>Can some1 help me as how this can be done? Macro is fine with me. Also I have huge data like 5000+ Values.</p>