Query required for People attended different program

i need query which can map data of each user who attened different programs(All programs are in one cell per user) to be mapped to each user attending each program.


Cell1        cell2         cell3          cell4

Name1     Ph1         Email1    Program1-1,program1-2..program1-10

Name2     Ph2      Email2          Program2-1,program2-2..program2-9

Name3     Ph3         Email3          Program3-1,program3-2..program3-5

Name4     Ph4         Email4          Program4-1,program4-2..program4-19

. .       .          .  

. .             .                  .

Name5000 Ph5000 Email5000     Program5000-1,program5000-2..program5000-19




Map the data to

Cell1        cell2         cell3          cell4

Name1     Ph1         Email1    Program1-1

Name1     Ph1      Email1          Program1-2

Name1     Ph1         Email1          Program1-3

Name1     Ph1         Email1          Program1-4

. .       .          .  

Name2     Ph2         Email2 Program2-1

.        .              .                   . 


Name5000 Ph5000 Email5000     Program5000-19



Please let me know how this can be done


13 thoughts on “Query required for People attended different program

  1. http://tinyurl.com/sgckkmw

    Having read this I believed it was really enlightening.
    I appreciate you taking the time and energy to put this short article together.
    I once again find myself spending a lot of time both reading and commenting.

    But so what, it was still worthwhile!

  2. quest bars cheap

    Hey I know this is off topic but I was wondering if you
    knew of any widgets I could add to my blog that automatically tweet my newest twitter
    updates. I’ve been looking for a plug-in like this for quite some time and was hoping
    maybe you would have some experience with something like this.
    Please let me know if you run into anything. I truly enjoy reading your blog and I look forward to your
    new updates.

  3. ps4 games

    I’m extremely impressed with your writing skills and also with the layout on your weblog.
    Is this a paid theme or did you modify it yourself?

    Anyway keep up the nice quality writing, it is rare to see
    a nice blog like this one today.

  4. ps4 games

    What’s up it’s me, I am also visiting this web page
    regularly, this web site is actually pleasant and the users are really sharing pleasant thoughts.

  5. coconut oil

    Oh my goodness! Awesome article dude! Many thanks, However I am experiencing troubles with your RSS.
    I don’t understand the reason why I cannot join it.

    Is there anybody getting similar RSS issues? Anyone that knows the solution can you kindly respond?

  6. sling tv

    Hello would you mind sharing which blog platform you’re using?
    I’m looking to start my own blog in the near future but I’m having a hard time deciding
    between BlogEngine/Wordpress/B2evolution and Drupal.

    The reason I ask is because your design and style seems different
    then most blogs and I’m looking for something unique. P.S My apologies for getting
    off-topic but I had to ask!

  7. sling tv

    I have learn some excellent stuff here. Definitely worth bookmarking for
    revisiting. I wonder how a lot attempt you place to create this kind of excellent informative website.

  8. sling tv

    Heya i’m for the first time here. I came across this board
    and I in finding It really useful & it helped me out much.
    I am hoping to offer something again and aid others like you helped me.

Leave a Reply

Your email address will not be published. Required fields are marked *