title: Need help in creating a view with following data
body: <p>I have a table like </p>
  
  <pre><code>A | All,
  B | X,
  C | Y,
  D | Z
  </code></pre>
  
  <p>so I have to create a view replacing all with rest of the values in column.
  So my desired output will be</p>
  
  <pre><code>A | X,
  A | Y,
  A | Z,
  B | X,
  C | Y,
  D | Z
  </code></pre>
  
  <p>Thanks in advance!</p>