How to combine the duplicate text values in one column and count/sum the values in other columns
I need some helps to achieve a goal between the source data sheet and a different output in destination sheet. Basically I am trying to combine duplicate texts in column "Facility Name" from source sheet shown below to a new sheet and group the value of sums or counts in totals for that combined text value. I don't necessarily need to keep the ID column in the New Sheet. I know there must be the formulas that can solve these type of inquires.
Many thanks in advance!
Source Data sheet
New Sheet Output
Help Article Resources
Check out the Formula Handbook template!