Copy certain fields of the same record to a new worksheet based on a met condition and populate additional fields automatically

[ExcelIsEverything]

I have a schedule that I have prepared in Excel. I'm looking for a way to convert the schedule to a table that contains the Project and Staff and the hours for each date and the date in a unique record. I want to create as many copies of each row as there are non zero numbers in the schedule G:U. I want columns E (Project) and F (Staff) to be copied to each record and I want a new column Daily(Hours) and Date to be added to each record. I have attached a file containing the Before (above) and After (below) of how I would like to manipulate the data.

For Project 001 in Row 2, there are three cells in G2:U2 with non zero numbers. I want that single row to become a total of three rows with 8 Daily(Hours) on 5/10/21, 8 Daily(Hours) on 5/11/21, and 4 Daily(Hours) on 5/12/21.

I have been watching many videos to try to figure out how to do this without success. I would really appreciate it if someone could point me in the right direction.

Sample.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U
1	Budget(hours)	Check	Start date	Due date	Project	Staff	5/10/2021	5/11/2021	5/12/2021	5/13/2021	5/14/2021	5/17/2021	5/18/2021	5/19/2021	5/20/2021	5/21/2021	5/24/2021	5/25/2021	5/26/2021	5/27/2021	5/28/2021
2	20	20	10-May	1-Jun	001	Sam	8	8	4	0	0	0	0	0	0	0	0	0	0	0	0
3	16	16	10-May	1-Jun	002	Kelly	8	8	0	0	0	0	0	0	0	0	0	0	0	0	0
4	60	60	12-May	1-Jun	003	Sam	0	0	4	8	8	8	8	8	8	8	0	0	0	0	0
5	20	20	12-May	1-Jun	004	Kelly	0	0	8	8	4	0	0	0	0	0	0	0	0	0	0
6	6	6	14-May	20-Jun	005	Kelly	0	0	0	0	4	2	0	0	0	0	0	0	0	0	0
7
8
9
10	Project	Staff	Daily(hours)	Date
11	001	Sam	8	10-May
12	001	Sam	8	11-May
13	001	Sam	4	12-May
14	002	Kelly	8	10-May
15	002	Kelly	8	11-May
16	003	Sam	4	12-May
17	003	Sam	8	13-May
18	003	Sam	8	14-May
19	003	Sam	8	15-May
20	003	Sam	8	16-May
21	003	Sam	8	17-May
22	003	Sam	8	18-May
23	003	Sam	8	19-May
24	004	Kelly	8	12-May
25	004	Kelly	8	13-May
26	004	Kelly	4	14-May
27	005	Kelly	4	14-May
28	005	Kelly	2	15-May
DataEntryBefore

Cell Formulas
Range	Formula
B2:B6	B2	=SUM(G2:U2)

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B3:B6	Cell Value	=$A3	text	NO
B2	Cell Value	=$A2	text	NO