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


41 thoughts on “Query required for People attended different program

  1. Acheter Melanotan 2

    Hey there! I know this is somewhat off topic but I was wondering if you knew where I could get a captcha plugin for my comment form? I’m using the same blog platform as yours and I’m having trouble finding one? Thanks a lot!

  2. anabolika online bestellen

    I am really impressed together with your writing talents as well as with the layout for your weblog. Is this a paid theme or did you customize it your self? Either way keep up the excellent quality writing, it is rare to peer a nice weblog like this one nowadays..

  3. Order Sibutril in England

    It’s a pity you don’t have a donate button! I’d without a doubt donate to this excellent blog! I suppose for now i’ll settle for bookmarking and adding your RSS feed to my Google account. I look forward to new updates and will talk about this website with my Facebook group. Talk soon!

  4. acheter steroides France

    Can I just say what a relief to search out somebody who really knows what theyre speaking about on the internet. You undoubtedly know find out how to bring a problem to mild and make it important. Extra people must learn this and perceive this side of the story. I cant consider youre no more common because you undoubtedly have the gift.

  5. Billig

    This web site is really a walk-through for all of the info you wanted about this and didn’t know who to ask. Glimpse here, and you’ll definitely discover it.

  6. Acheter Mesterolone

    I will right away grab your rss feed as I can not to find your e-mail subscription link or newsletter service. Do you’ve any? Please allow me recognise in order that I may subscribe. Thanks.

  7. Alannah

    I loved as much as you will receive carried out right here.
    The sketch is tasteful, your authored material stylish.
    nonetheless, you command get got an nervousness over that you wish be delivering the following.
    unwell unquestionably come more formerly again as exactly the same nearly a lot often inside case you shield this increase.

  8. Cody Thacher

    Terrific work! This is the type of info that are supposed to be shared across the net. Shame on the seek engines for no longer positioning this put up upper! Come on over and discuss with my website . Thank you =)

  9. have a peek at this website

    What i don’t realize is in fact how you’re no longer really a lot more smartly-preferred than you might be now. You are very intelligent. You know therefore significantly relating to this matter, made me in my view imagine it from so many varied angles. Its like women and men don’t seem to be fascinated except it’s something to do with Woman gaga! Your own stuffs great. All the time maintain it up!

  10. Buy Supplements

    Thank you, I’ve recently been looking for info approximately this topic for a long time and yours is the best I’ve came upon so far. However, what in regards to the conclusion? Are you positive concerning the supply?

  11. Buy Wooden Handicraft

    I’m impressed, I need to say. Actually hardly ever do I encounter a weblog that’s each educative and entertaining, and let me let you know, you will have hit the nail on the head. Your concept is excellent; the difficulty is something that not enough persons are speaking intelligently about. I’m very glad that I stumbled across this in my seek for one thing referring to this.

  12. sling tv best package 2020

    Fantastic beat ! I would like to apprentice while you amend your website, how can i subscribe
    for a weblog site? The account aided me a acceptable
    deal. I had been a little bit acquainted of this your broadcast
    offered vivid transparent idea

  13. 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.

  14. 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.

  15. 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!

  16. 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?

  17. 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.

  18. 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.

  19. 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.

  20. 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!

Comments are closed.