title: Is there a way in excel to transpose an entire column of data, yet only display cells that contain text (or values)?
body: <p>Example of data I am looking at</p>
  
  <p><img src="https://i.stack.imgur.com/duC1z.jpg" alt="enter image description here"></p>
  
  <p>Example of end result I am trying to achieve automatically</p>
  
  <p><img src="https://i.stack.imgur.com/ZMMmK.jpg" alt="enter image description here"></p>