title: Excel: Transpose Like Rows into Columns
body: <p>I have an excel spreadsheet that has student names in the first column and then some corresponding information for that student in other columns. Student names have been changed for privacy. </p>
  
  <p><img src="https://i.stack.imgur.com/v2pUX.png" alt="enter image description here"></p>
  
  <p>You'll notice that I have multiple students in a column because there are 2 (or more) test scores in that last column. </p>
  
  <p>I need to have 1 student per row so I'd like to take the other scores and make those columns. So for that first student there would be a Mean Score 1 and Mean Score 2.</p>
  
  <p>Is this possible?</p>