Lookup to return top 10 of each area

[Danster1979]

Hi all,

Thanks in advance for anyone who looks and helps me on this one, that is driving me crazy.

I am looking to create a page that looks up each of my separate areas, and then returns a Top 10 (1-10) for each area with account number and the value outstanding with that account.

I am sorry I am vague but thanks to GDPR I am not allowed to input too much info, I have pasted the below from my list (not full) but for some reason it goes all over the place

A = Area / B = Balance / C = Account Number / D = Query Age

What I would like to see is

Area Query Hub
1 / Balance / Account / Age
2
3
4
etc

Area Billing
1 / Balance / Account / Age
2
3
4
etc

This is how my list is setup

Area Balance Account Number Query Age(Data)
Query Hub £77,071.12 a1 147
Billing £49,891.46 a2 21
Billing £37,836.05 a3 13
Query Hub £37,251.84 a4 284
Query Hub £37,182.94 a5 346
Billing £32,880.40 a6 221
Query Hub £31,695.01 a7 104
Billing £30,230.50 a8 145
Change of Occupancy £29,544.51 a9 259
Billing £26,905.41 a10 116
Query Hub £25,757.57 a11 301
Losses £25,604.59 a12 158
Losses £24,823.60 a13 46
Billing £24,547.30 a14 116
Query Hub £24,510.19 a15 544
Billing £24,508.57 a16 508
Billing £24,234.22 a17 18
Billing £23,796.65 a18 14
Collections £23,611.98 a19 84
Query Hub £22,659.12 a20 137
Query Hub £22,525.82 a21 222
Query Hub £22,212.98 a22 10
Query Hub £21,750.99 a23 95
Query Hub £21,295.03 a24 46
Losses £21,159.44 a25 90
Query Hub £20,858.86 a26 88
Billing Alignment £20,750.68 a27 132
Losses £20,176.15 a28 27
Meter Reads in Error £20,051.47 a29 300
Billing Alignment £19,359.82 a30 346
Query Hub £18,850.45 a31 6
Query Hub £17,341.15 a32 185
Query Hub £17,301.42 a33 80
Query Hub £17,246.16 a34 266
Billing Alignment £17,083.12 a35 193
Collections £16,999.43 a36 365
Query Hub £16,866.38 a37 437
Query Hub £16,727.40 a38 42
Customer Take On £16,705.08 a39 229
Billing £16,435.02 a40 49
Lean Reads £16,092.96 a41 166
Billing £16,007.13 a42 138
Losses £15,955.28 a43 140
Query Hub £15,940.28 a44 144
Query Hub £15,881.95 a45 502
Query Hub £15,837.35 a46 277
Query Hub £15,620.29 a47 567
Query Hub £15,401.17 a48 294
Query Hub £15,203.86 a49 601
Billing Alignment £15,151.20 a50 489
Query Hub £14,928.06 a51 181
Meter Reads in Error £14,766.53 a52 133
Query Hub £14,541.99 a53 639
Query Hub £14,458.30 a54 361
Losses £14,438.68 a55 53
Query Hub £14,319.75 a56 592
Query Hub £14,317.23 a57 557
Query Hub £14,291.98 a58 320
Billing £14,179.42 a59 33
Query Hub £14,061.19 a60 217
Billing £13,620.12 a61 95
Billing £13,468.29 a62 124
Query Hub £13,055.84 a63 291
Query Hub £12,898.78 a64 73
Closed Call £12,808.50 a65 392
Query Hub £12,784.32 a66 314
Query Hub £12,784.32 a67 314
Query Hub £12,741.12 a68 174
Billing Alignment £12,714.33 a69 48
Losses £12,605.14 a70 132
Query Hub £12,565.65 a71 48
Query Hub £12,514.59 a72 655
Query Hub £12,481.74 a73 378
F.E.P Energisation £12,287.22 a74 122
Losses £12,054.18 a75 42
Query Hub £11,869.56 a76 175
Billing £11,679.23 a77 33
Billing £11,640.58 a78 46
Query Hub £11,552.46 a79 271
Query Hub £11,532.47 a80 669
Query Hub £11,491.68 a81 299
Query Hub £11,354.91 a82 381
Losses £11,029.78 a83 79
Query Hub £10,976.16 a84 102
Collections £10,874.07 a85 354
Billing £10,854.74 a86 3
Lean Reads £10,762.90 a87 201
Losses £10,720.61 a88 56
Query Hub £10,583.33 a89 196
Lean Reads £10,550.80 a90 5
Registration £10,443.60 a91 90
Query Hub £10,346.63 a92 420
Billing Alignment £10,346.12 a93 253
Billing Alignment £10,210.89 a94 468
Query Hub £10,171.31 a95 194
Query Hub £10,099.26 a96 300
Billing £10,078.29 a97 32
Query Hub £9,955.34 a98 734
Query Hub £9,867.89 a99 147
Billing £9,857.86 a100 266
Closed Call £9,777.01 a101 96
Query Hub £9,688.54 a102 220
Losses £9,639.23 a103 26