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.

Example:

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

By: KRISHNA PAL

Leave a Reply

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