Thread: Reducing data into a new table

I have a table that captures bargaining data between a & b. In a nutshell, "a" is looking to buy low, and "b" is looking to sell high. The table looks like this:

(sorry for the poor formatting...it looked good in the editor!)
Group,Rd, From, To, Offer
1 1 a b 3
1 1 b a 5
1 1 a b 4
1 1 b a 5
1 2 b a 6
1 2 a b 2
1 2 a b 3
2 1 b a 5
2 1 a b 2
2 1 b a 4
.
.
(goes on for 8500 rows).

I need to simplify the above into a table like this:

Group,Rd, Initiated by A, A's 1st offer
1 1 1 3
1 2 0 2
2 1 0 2

Any advice on how I could do this in VBA?

I was thinking that one way to get the "Initiated by A" information was to compare the row at which "a" first occurs for a particular group in that specific round with the row that "b" first occurs. If the former is smaller than the latter, then a "1" is input into the "Initiated by A" column. The problem is, I don't know how to implement this comparison since "a" and "b" could go back and forth any number of times. Is there an easier way to get this done? Same problem with the comparison with the "A's 1st offer" column". Sigh...

Help would be greatly appreciated!
-KG