I have a CSV file as follows:
"ID","M1","M2","M3" "122",10,20,30 "122",30,0,30 "210",0,0,10 "210",10,0,0 "210",0,10,0
Using Group-object how can I produce
a new CSV file that looks like:
"ID","M1","M2","M3" "122",40,20,60 "210",10,10,10
Can Group-object accomplish this?
Thanking you in advance for any advice
or tips and hints.