Look for data

Hello,

I have a query which I hope someone will be able to assist me with as I am finding it quite complex.

I have the following problem:

Column Column Column Column

X1111
-A 34 2790500 34
-B 11 1415999 11
Total 45 4206499 45
X1110
-A 9 1342875 9
-B 4 306000 4
Total 13 1648875 13
X1101
-A 12 1567560 12
-B 4 506595 4
Total 16 2074155 16
X1010
-A 33 5138350 33
Total 33 5138350 33
X0101
-A 2 182000 2
Total 2 182000 2

What I now require is for another column (or a different spreadsheet) to list the X code and the following column after that to list the value of the first A letter that comes after the above X code. The same for B and total.

Many thanks!