Loop through values in one column and extract values from another?

I'm new to the forum, but I've been struggling with this for a few weeks now and need some help...

Excel Example.png

Above is a small sample of the data I'm working with. Basically, what I want to do is loop through the values in column B. Whenever the value changes (in this instance, from 8088 to 8630), I want to take the values in column D and G (in the same row) as 8088 and place them in another worksheet.

Is this possible? If so, what is the best approach to accomplish it?

Hello Sarah07282;

I'd like to get some clarification on what you're asking; Are you saying you want to 1. look through columb B and 2. anytime, for instance, B1 is not equal to B2 you want to display what's in D1 and G1 and display it in i. another worksheet or ii. another workbook? Thanks

Another worksheet would be good, but another workbook is fine as well.

And yes, look through column B, and anytime B1 is not equal to B2, look at D1 and G1.

This formula should work. =IF(B1<>B2,D1&" "&G1,"")
You can drag it it down using the crosshare and it will autofill from top to bottom. Let me know how it goes. I'm assuming you want the info from D1 and G1 in one cell with a space in between. If not, let me know.

Jesse1983