yogi_Formula In Cell E4 For Cells E4 To E To Create A Table For Each Event And Name As Noted In Sheet1 and Sheet2

                    Google Spreadsheet   Post  #1769
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Sep-24-2014
post by  nelipot:
(https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/YTHBIm5QDGo)
How to create a new set of data rows from 2 columns

Hi guys -   I need to take data from 2 columns and produce a third data set as shown below. See spreadsheet here

https://docs.google.com/spreadsheets/d/1tvsrwAwu5RLJjFFuMfRaogIY1pBPEQzGOnezn8uEdlk/edit?usp=sharing

There is a lot of data spread across sheets and it is an ongoing process (new names) - if i can automate it with a formula or macro in Sheet 3 that would be brilliant :)

Sheet 1		Sheet 2		Sheet 3
				result needed
Events		People		Person	Event
Screening		John		John	Screening
Treating		James		John	Treating
Followup		Jack		John	Followup
				James	Screening
				James	Treating
				James	Followup
				Jack	Screening
				Jack	Treating
				Jack	Followup

------------------------------------------------------------------------------------------------------------------------