Hi, I have a project in my hands I don't know where to start to automate it (I don't have time to do it manually). I'm using Excel 2004, in a Mac.
I have a spreadsheet exported from our database with a few columns for a few thousand individual records. Each individual record (a row) includes columns for "First Name", "Last Name", "Title" and "Phone Number". I need an automated way to reformat those 4 columns (either on that existing spreadsheet or into a separate spreadsheet) so they are merged into a single column in this exact format: {First Name Last Name, Title.....Phone Number; } (minus the {}'s) What is the best way to go about doing this? Thank you!
Bookmarks