Hi @IrynaK
There is a One Row to Many node that will expand your one Antenna row to 17 rows. After this, you can apply a Group Loop Start node to operate on each individual item of equipment, and use the Rule Engine node to apply rates based on row indices (rows 1-6 will get one value, rows 7-12 another, etc).
After this you can Group By ‘equipment’ and ‘rate’ to get your 3 rows with equipment name, counts and rates.
Split Row into multiple.knwf (30.9 KB)