How do I filter out cells that I want so then I can copy the information next to it to paste the filtered data onto a new sheet?

im new to using excel because of uni and im struggling trying to filter my data so that i can calculate confidence intervals.

So basically i started off with two columns cbd dist and median price, but i need to assign words to the cbd dist values (the cbd dist values r in km, and inner is assigned to a value that is less than or equal to 14.75km) which i managed to do after ages googling.

However now I want to only copy the inner group and its corresponding median price values so that i can paste it nicely on another excel sheet for my calculations (as its mixed with outer right now, i also need to split the values so i just have a list of outer and its numbers).

So I need something where i can highlight all the inner and then just control shift left so i can get the median values.

Does anyone know how I can do this?? Thanks in advance and I’d really appreciate all the help I can get as im stumped atm.

Also im new to this subreddit and my old post with an image of the data got removed, lmk if you guys need a ref