title: How to get multiple values with a single look up in Excel with transposing the data from column to rows
body: <p>How do I get multiple values with a single look up in Excel with transposing the data from column to rows.</p>
  
  <p>Please see below image for how data is.</p>
  
  <p>Input data:</p>
  
  <p><a href="https://i.stack.imgur.com/JlKuZ.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/JlKuZ.jpg" alt="enter image description here"></a></p>
  
  <p>Output data:</p>
  
  <p><a href="https://i.stack.imgur.com/UvuIE.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/UvuIE.jpg" alt="enter image description here"></a></p>