Can I split multiple columns but leave some cells merged?

I have a csv file with loads of data. It looks like the below screenshot:
enter image description here.

Basically what I need is to split 2 columns into rows with power query (reference 1 and Delivery).
Reference 1 is always separated by space and Delivery data is always separated by line feed.
So it would look like the below screenshot, so each reference is matched up to its delivery.
However I need the miles and the price NOT to be duplicated as this would give us wrong total numbers, so I need those merged. (There's also a Job no column in case this would help - this would indicate if 2 or 3 deliveries were done together.
This is how I would need it:
enter image description here

Any help would be appreciated

I have tried splitting the columns separately but then it duplicates data and I would still need to manually delete the extra rows.

I need it in the below format (but with the duplicated miles&price merged into 1), but I can't find a solution anywhere.

Using Power Query, it is not possible to produce "Merged Cells". The code below only writes the miles and price amounts into the first row of the entries for a particular Job No. You would then have to merge the cells manually or by using a VBA routine.

There are other options, but if you must have merged cells, you will need to develop a VBA solution for that.

Paste the code below into the Advanced Editor, changing the second line to reflect your actual Table Name in your workbook.

Read the code comments and explore the Applied Steps to understand the algorithm. The new table is created by applying the Tables.FromColumns method to each subgroup of Job No.

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Changed Type" = Table.TransformColumnTypes(Source,{
        {"Job No.", type text}, {"Date", type datetime}, {"Reference 1", type text}, 
        {"Delivery", type text}, {"Miles", Int64.Type}, {"Price", type number}},"en-GB"),

//Group by Job number
//then split into rows
//Price and miles only on first row
    #"Grouped Rows" = Table.Group(#"Changed Type", {"Job No."}, {
        {"New Table", (t)=>Table.FromColumns(
                {t[#"Job No."]}
                 & {t[Date]}
                 & {Text.Split(t[Reference 1]{0}," ")}
                 & {Text.Split(t[Delivery]{0},"#(lf)")}
                 & {t[Miles]}
                 & {t[Price]},
            Table.ColumnNames(t)),
            type table [#"Job No."=nullable text, Date=nullable datetime, Reference 1=nullable text, Delivery=nullable text, Miles=nullable number, Price=nullable number]   
            }}),

//Expand the grouped tables exceot for Job No.
    #"Expanded New Table" = Table.ExpandTableColumn(#"Grouped Rows", "New Table", 
        {"Date", "Reference 1", "Delivery", "Miles", "Price"}),

//Fill down the date column
    #"Filled Down" = Table.FillDown(#"Expanded New Table",{"Date"})
in
    #"Filled Down"

Your Original Data<br>

Results from Above<br>