With Google sheets can importHTML be combined with a formula like arrays and filters. I can perform these tasks after using importHTML manually. Array to split data in one cell into three columns and filter to remove blank cells.
I can use macros to perform these tasks or use Automator in Mac.
I have a sneaky feeling this is the limitation of importHTML maybe a solution with AppleScript or JavaScript. Python maybe a easier option.