My data looks like this (there is actually 5k rows of data)

Stock Price
AA 1
AA 2
AA 3
AA 4
BB 1
BB 2
BB 3


I am looking for a formula that will produce this table:

Stock Low High
AA 1 4
BB 1 3

Thank you in advance.