For my company's upcoming conference, we need to have each attendee's name and sessions formatted onto a single row in Excel. So First Name in A2, session one in B2, session two in C2, etc. When you export the attendees and their chosen sessions from our event management site, it formats them incorrectly (which can't be changed.) It just repeats each attendee. So first name in A2, with session one in B2. First name in A3, with session two in B3, first name in A4, with session three in B4. How can I get the sessions onto a single row, with the name only showing once? Example.xlsx