Introduction How do you convert vertical data into horizontal data in Excel? This was a question I was asked this week. A friend of mine was asked to convert an Excel spreadsheet that contained a list of classes and their students from one long column of text to rows of classes and their students. What…