MYOB Reports

Hi

Please see attached Report - Original File is "MYOB" Tab - is the anyway to produce the "reports" tab highlighted  either by power query  or other ways - trying to extract job no. and Job name and then fill down so in table format and from there we can create a power pivot to report on the job no and Job name.