Formula for getting all names just once wether they are duplicate of unique

Dear All;
Could someone assist me in creating a sheet called "Analysis" that performs calculations based on the combinations of data in Columns A, B, and C from another sheet named "LHW Monthly Progress"? Currently, the sheet functions correctly when I manually enter values into Columns A, B, and C of the Analysis sheet.

However, I am facing difficulties in automatically displaying all unique values in the Analysis sheet's columns as soon as data is entered into the "LHW Monthly Progress" sheet. Ideally, when a combination of data is entered into the "LHW Monthly Progress" sheet, it should be added to the Analysis sheet, and the corresponding value in Column F to column Q.

for better understanding please find attached the sheet

best
Jibran

hi, I want to populate all unique rows in sheet2 from sheet1. all unique rows + duplicates at 1 time.

please find attached the Excel.

Dear Glenn;
Thanks for the wonderful work this formula is working 80% fine but it's missing values like mentioned below district formula just shows the " Hassan BiBi" rest 3 of entries got
missed out and this goes for other districts as well. Can you please update the formula so that it could display all unique entries?

Day District Facility Name
Dec-21 Sheikhan Hassan BiBi
Jan-22 Sheikhan FP Ibrahim
Jan-22 Sheikhan FP Shafia
Jan-22 Sheikhan Shazia

I must say you solve the maximum problem which I was facing for the last 3 days :S

waiting for your positive reply

Best
Jibran

Thanks a lot, dear it's working perfectly fine. Now I will apply it to my data which consists of thousands of rows. if anything happened will let you know