I have a table odds where
MATCH_ID | HOME_ID |Away_ID | Group_name | Line_name | Odd |
3000 | 1 | 2 | 1x2 | Chelsea | 1.4
3000 | 1 | 2 | 1x2 | Liverpool | 2.8
3000 | 1 | 2 | Handicap | Chealse - 1.5 | 2.9
3000 | 1 | 2 | Handicap | Liverpool +1.5 | 1.4
every match has odds related to this match.
How i could get the odds listed like they are on bookmaker websites like Bet365 when you click on some event and they are grouped and related?
Expected output:
Thank you!
As you can see in the picture "To Win" would be 1x2 on my table.
As well as Point Betting would be Handicap