Question

How do I to format Jotform multi-select options as separate rows in Excel?

  • 25 April 2022
  • 2 replies
  • 82 views

Userlevel 1

i have a form as follows

  1. Name - John Doe
  2. Email - john.doe@hotmail.com
  3. Multi select field
    1. Marketing
    2. HR

it comes through on excel like this

John Doe john.doe@hotmail.com marketing; hr

 

 

i i would like it like this

 

John Doe john.doe@hotmail.com marketing
John Doe john.doe@hotmail.com hr

 

whats the best way to do this?


This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

2 replies

Userlevel 7
Badge +9

Hey @sp2222 were you able to try looping to solve the issue here? We know Looping is a bit of an advanced feature so let us know where you’re at and we can jump in to guide you in the right direction with setting this up!

Userlevel 7
Badge +14

Hi @sp2222 

Good question.

Try using the Looping app to handle line items: https://zapier.com/apps/looping/help