I have exported database data from my OCS conference and I'm trying to open the xml file in Excel. I wish to use the data in a mail merge.
Instead of First Name, Last Name, Address, etc. appearing in one row for each person, each column appears in a successive row. (i.e. First name appears in cell A1, Surname in B2, Address in C3, etc.)
Obviously, this isn't very useful for doing a mail merge in Word. Any suggestions?