Wednesday, September 24, 2014

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

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 1Sheet 2Sheet 3
result needed
EventsPeoplePersonEvent
ScreeningJohnJohnScreening
TreatingJamesJohnTreating
FollowupJackJohnFollowup
JamesScreening
JamesTreating
JamesFollowup
JackScreening
JackTreating
JackFollowup
------------------------------------------------------------------------------------------------------------------------