 |
 |
Hi my esteemed listmates, I’m launching a new library contest. I’d like to be able to sort participants by their given and surnames and the names of their submitted project names alphabetically and for all the data included in the respective columns. I was contemplating this… Column A = Last name Column B = First name Column C = their email address Column D = their phone number Column E = their project name Column F = if they participated before (or first time) in any library program Say I wish to sort alphabetically by last or first name or by project name or by if they’re a 1st time participant, etc. I’ve learned with Excel it’s best to plan your columns for data before you start inputting their data. Would creating a Word Table in 365 be a better tool than Excel for this? I’m also trying to ensure that if I have the benefit of an online program (participants register on) I can export that data as a .csv file and that it will import all these fields into the correct respect columns? Ex. How do I ensure when I export the online file as a .csv that when it imports it doesn’t dump all the data into Column A but rather imports the last name into Column A, first name into Column B, etc.? Have you had to take extra measures to ensure all the data from an online program exports correctly into the Columns you’ set up in Excel or tables in Word? Thank you! Charles. Charles Meyer Charlotte County Public Library Port Charlotte, FL