Solve a google sheets formula
Budget: $15 – $25 AUD
I want someone how is free for 1 hour at 9 OR 10 am AEST Fri 22 October to share my screen (using Zoom) and help me solve the following formula issue:
Sheet 1 Column a = emails
Sheet 1 Column b-aa (Day 1, Day 25) = fields either populated with yes or empty
Sheet 2 Column A header = email
Sheet 2 column B = Day
Every time a cell in sheet one, column B to column AA returns the value Yes, add a new row in Sheet 2 with column A = Sheet 1 Column A of correlating Row where Yes was added, and Column B = name of Correlating Column header (ie Day1, Day 2 etc)
Sheet 1 Column a = emails
Sheet 1 Column b-aa (Day 1, Day 25) = fields either populated with yes or empty
Sheet 2 Column A header = email
Sheet 2 column B = Day
Every time a cell in sheet one, column B to column AA returns the value Yes, add a new row in Sheet 2 with column A = Sheet 1 Column A of correlating Row where Yes was added, and Column B = name of Correlating Column header (ie Day1, Day 2 etc)