Spreadsheet: 810560d1671850387-combine-data-in-2-rows-into-1-single-row-s666-pq-combine-data-in-4-rows-into-1-single-row
Sheet: Data

 | SETT_DATE | EVENT_ID | MENU_HINT | EVENT_NAME | PATHS | [NAME] | PARENT_EVENT_NAME | SELECTION_NAME | RESULT | INPLAY | MIN_PRICE | MAX_PRICE | LAST_MATCHED_PRICE | WAP | VOLUME_AUD
25 | 2018-03-03 00:00:00 | 140358525 | JLT Community Series 2018 / Western Bulldogs v Hawthorn | Match Odds | JLT Community Series 2018/Western Bulldogs v Hawthorn | Australian Rules / JLT Community Series 2018 | Western Bulldogs v Hawthorn | Hawthorn | L | N | 2 | 2.46 | 2.12 | 2.15852467024915 | 946.81938
26 | 2018-03-03 00:00:00 | 140358525 | JLT Community Series 2018 / Western Bulldogs v Hawthorn | Match Odds | JLT Community Series 2018/Western Bulldogs v Hawthorn | Australian Rules / JLT Community Series 2018 | Western Bulldogs v Hawthorn | Western Bulldogs | W | N | 1.67 | 1.89 | 1.89 | 1.81910523464815 | 722.52306
27 | 2018-03-03 00:00:00 | 140358525 | JLT Community Series 2018 / Western Bulldogs v Hawthorn | Match Odds | JLT Community Series 2018/Western Bulldogs v Hawthorn | Australian Rules / JLT Community Series 2018 | Western Bulldogs v Hawthorn | Hawthorn | L | Y | 1.64 | 4 | 4 | 2.41569911384699 | 525.97914
28 | 2018-03-03 00:00:00 | 140358525 | JLT Community Series 2018 / Western Bulldogs v Hawthorn | Match Odds | JLT Community Series 2018/Western Bulldogs v Hawthorn | Australian Rules / JLT Community Series 2018 | Western Bulldogs v Hawthorn | Western Bulldogs | W | Y | 1.05 | 1.34 | 1.05 | 1.30292877772998 | 578.99334
29 | 2018-03-03 00:00:00 | 140358532 | JLT Community Series 2018 / Brisbane v Sydney | Match Odds | JLT Community Series 2018/Brisbane v Sydney | Australian Rules / JLT Community Series 2018 | [NAME] | Sydney Swans | W | N | 1.27 | 1.4 | 1.3 | 1.30463353790454 | 3223.40568
30 | 2018-03-03 00:00:00 | 140358532 | JLT Community Series 2018 / Brisbane v Sydney | Match Odds | JLT Community Series 2018/Brisbane v Sydney | Australian Rules / JLT Community Series 2018 | [NAME] | Brisbane Lions | L | N | 3.4 | 4.4 | 3.8 | 4.0394364774793 | 1056.93948
31 | 2018-03-03 00:00:00 | 140358532 | JLT Community Series 2018 / Brisbane v Sydney | Match Odds | JLT Community Series 2018/Brisbane v Sydney | Australian Rules / JLT Community Series 2018 | [NAME] | Brisbane Lions | L | Y | 1.76 | 1.76 | 1.76 | 1.76 | 53.97486
32 | 2018-03-03 00:00:00 | 140358532 | JLT Community Series 2018 / Brisbane v Sydney | Match Odds | JLT Community Series 2018/Brisbane v Sydney | Australian Rules / JLT Community Series 2018 | [NAME] | Sydney Swans | W | Y | 1.01 | 1.22 | 1.01 | 1.06908609211539 | 785.64198
33 | 2018-03-04 00:00:00 | 140358549 | JLT Community Series 2018 / Gold Coast v Geelong | Match Odds | JLT Community Series 2018/Gold Coast v Geelong | Australian Rules / JLT Community Series 2018 | Gold Coast v Geelong | Gold Coast Suns | W | N | 1.83 | 2.18 | 1.83 | 1.94643244657654 | 10198.1175
34 | 2018-03-04 00:00:00 | 140358549 | JLT Community Series 2018 / Gold Coast v Geelong | Match Odds | JLT Community Series 2018/Gold Coast v Geelong | Australian Rules / JLT Community Series 2018 | Gold Coast v Geelong | Geelong Cats | L | N | 1.84 | 2.16 | 2.12 | 2.03036584870729 | 8763.49632
35 | 2018-03-04 00:00:00 | 140358549 | JLT Community Series 2018 / Gold Coast v Geelong | Match Odds | JLT Community Series 2018/Gold Coast v Geelong | Australian Rules / JLT Community Series 2018 | Gold Coast v Geelong | Gold Coast Suns | W | Y | 1.34 | 1.48 | 1.48 | 1.42896825396825 | 183.80628
36 | 2018-03-04 00:00:00 | 140358549 | JLT Community Series 2018 / Gold Coast v Geelong | Match Odds | JLT Community Series 2018/Gold Coast v Geelong | Australian Rules / JLT Community Series 2018 | Gold Coast v Geelong | Geelong Cats | L | Y | 2.04 | 3.05 | 3.05 | 2.16249848392965 | 58.67142
37 | 2018-03-07 00:00:00 | 140761702 | JLT Community Series 2018 / Richmond v North Melbourne | Match Odds | JLT Community Series 2018/Richmond v North Melbourne | Australian Rules / JLT Community Series 2018 | Richmond v North Melbourne | Richmond | W | N | 1.18 | 1.29 | 1.24 | 1.24406539116476 | 13090.045224
38 | 2018-03-07 00:00:00 | 140761702 | JLT Community Series 2018 / Richmond v North Melbourne | Match Odds | JLT Community Series 2018/Richmond v North Melbourne | Australian Rules / JLT Community Series 2018 | Richmond v North Melbourne | North Melbourne | L | N | 4.3 | 5.3 | 5.2 | 5.14992506957825 | 1160.547318
39 | 2018-03-07 00:00:00 | 140761702 | JLT Community Series 2018 / Richmond v North Melbourne | Match Odds | JLT Community Series 2018/Richmond v North Melbourne | Australian Rules / JLT Community Series 2018 | Richmond v North Melbourne | Richmond | W | Y | 1.01 | 1.47 | 1.01 | 1.16766146438121 | 16658.93143
40 | 2018-03-07 00:00:00 | 140761702 | JLT Community Series 2018 / Richmond v North Melbourne | Match Odds | JLT Community Series 2018/Richmond v North Melbourne | Australian Rules / JLT Community Series 2018 | Richmond v North Melbourne | North Melbourne | L | Y | 3.1 | 110 | 110 | 5.89386637101771 | 2176.988996
41 | 2018-03-08 00:00:00 | 140761704 | JLT Community Series 2018 / [NAME] | Match Odds | JLT Community Series 2018/[NAME] | Australian Rules / JLT Community Series 2018 | Melbourne v [NAME] | [NAME] | L | N | 2.84 | 3.1 | 2.88 | 2.94169066736014 | 2186.757092
42 | 2018-03-08 00:00:00 | 140761704 | JLT Community Series 2018 / [NAME] | Match Odds | JLT Community Series 2018/[NAME] | Australian Rules / JLT Community Series 2018 | Melbourne v [NAME] | Melbourne Demons | W | N | 1.46 | 1.55 | 1.48 | 1.49619433144823 | 5373.41727
43 | 2018-03-08 00:00:00 | 140761704 | JLT Community Series 2018 / [NAME] | Match Odds | JLT Community Series 2018/[NAME] | Australian Rules / JLT Community Series 2018 | Melbourne v [NAME] | [NAME] | L | Y | 1.8 | 8 | 2 | 3.23848533178677 | 735.399522
44 | 2018-03-08 00:00:00 | 140761704 | JLT Community Series 2018 / [NAME] | Match Odds | JLT Community Series 2018/[NAME] | Australian Rules / JLT Community Series 2018 | Melbourne v [NAME] | Melbourne Demons | W | Y | 1.01 | 2.26 | 2.06 | 1.28044431768199 | 5171.503168
45 | 2018-03-09 00:00:00 | 140761706 | JLT Community Series 2018 / Sydney v GWS | Match Odds | JLT Community Series 2018/Sydney v GWS | Australian Rules / JLT Community Series 2018 | [NAME] | GWS Giants | L | N | 2 | 2.1 | 2.06 | 2.05744276200258 | 4277.25132
46 | 2018-03-09 00:00:00 | 140761706 | JLT Community Series 2018 / Sydney v GWS | Match Odds | JLT Community Series 2018/Sydney v GWS | Australian Rules / JLT Community Series 2018 | [NAME] | Sydney Swans | W | N | 1.9 | 2 | 1.94 | 1.93448337777605 | 7281.14844
47 | 2018-03-09 00:00:00 | 140761706 | JLT Community Series 2018 / Sydney v GWS | Match Odds | JLT Community Series 2018/Sydney v GWS | Australian Rules / JLT Community Series 2018 | [NAME] | GWS Giants | L | Y | 1.3 | 50 | 50 | 4.44711639209746 | 1122.63498
48 | 2018-03-09 00:00:00 | 140761706 | JLT Community Series 2018 / Sydney v GWS | Match Odds | JLT Community Series 2018/Sydney v GWS | Australian Rules / JLT Community Series 2018 | [NAME] | Sydney Swans | W | Y | 1.01 | 3.15 | 1.03 | 1.18412153891958 | 5355.06735