How can i do a frequency distribution by machine automatically
 

Machine Speed Mac 1 Mac 2 Mac 3
Mac 1 100 100
Mac 1 200 200
Mac 3 300 300
Mac 1 400 400
Mac 2 500 500
Mac 2 100 100
Mac 2 200 200
Mac 1 500 500
Mac 3 800 800
Mac 3 1100 1100
Mac 3 1400 1400
Mac 3 1700 1700
Mac 3 700 700

How can i do a frequency distribution by machine automatically?
Current i use the index function to group them under the same machine
and follow by a "frequency" function. However, this way it will be
very slow,as the column under Mac 1, Mac 2 and Mac 3 need
to have the function "index". This get more slower when you have 6K
rows of data. How can i do it more efficiently ?