Join the Ready, Set, Send Challenge Week 3. Share your QR code or landing page and win a badge!

Entering an xls spreadsheet that is not "flat"

KenG56
Rookie
0 Votes
I'm working on a project that has a membership spreadsheet that is not flat, meaning, for example, a person's name, email address and physical address are all "stacked" in a spreadsheet column for each person's spreadsheet row. Similarly mobile and landline phone numbers are stacked in the same spreadsheet column. The number of members is approximately 150. Does anyone know of a way to automate the process of creating addition columns and moving information from the stacks into those new columns. This is a huge project if the flat spreadsheet has to be done by hand, likewise, to enter them directly into Constant Contact manually.
0 REPLIES 0
  • Avatar

    Featured Article

    Use Sections to Build Email Campaigns Faster and Improve Engagement Rates

    Using Sections while designing your marketing email not only increases your own efficiency but helps you to deliver a more friendly, organized message. Check out some of the key benefits of using sections in email.

    See Article
  • Avatar

    Featured Thread

    Casual Conversations: What's your go-to playlist?

    If you listen to music while you work, share your playlist below so we can be inspired and maybe find some new music!

    View thread
  • Avatar

    Featured Thread

    Ready, Set, Send Challenge: Week 3 - Audience Building

    Your email list is a valuable asset for your business. Let's learn the importance of growing it.

    Join challenge
Updates
Just Getting Started?

We’re here to help you grow. With how-to tutorials, courses, getting-started guides, videos and step-by-step instructions to start and succeed with Constant Contact.

Start Here

73% of SMBs express doubt that their marketing strategy is effective. Does this sound familiar? Read our Small Business Now Report to learn how you can tweak your strategy to see better results.

Go read our article
Upcoming Webinars
OCT 24
Engage and Convert: The Email and Social Media Power Play
2PM - 3PM EST