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


Leave a Reply

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