formua to Extract Values

I have a FDF file that I convert using conversion software, but the values are split over several columns


I am looking for a formula to extract the jumbled values from several columns


I have shown what the values should be


It would be appreciated if someone could assist me