I am copying and pasting information about some conferences from a large list of panels. When I find conferences that I am interested in, I copy and paste them into a big Word document, but I figure I can compare them more easily in an Excel spreadsheet.
Each entry is five lines. Here's a sample entry:
Session ID: 1234
Track Code: ABC
Session Name: How to Change the World
Time: 12:30 pm - 2:15 pm
What I'd like to do is convert the items in the first column into the top row of an Excel spreadsheet. This way, I can look at one single column for a list of dozens of session names and look down a single column to see what times they take place.
Is there an easy way to do this in Excel when the data I'm getting in the first place is in the above format? Many thanks!