Shift cells to the right in Power query?

[danhendo888]

Is it possible to move the highlighted columns below to the right in power query?

Start:

Invoice	Column3	Date	Ref	Due	Amount	Total
S00255628		15-Apr-24	Text	20-May-24	404.70	404.70
S00255629		15-Apr-24	Text	20-May-24	279.70	279.70
S00254878	28-Mar-24	PAYMENT REF: 00443161	20-Apr-24	479.64	479.64	25,387.81
W00001450	28-Mar-24	PAYMENT REF: 00443246	20-Apr-24	61.80	61.80	25,449.61
W00001484		15-Apr-24	Other	20-May-24	10.80
S00252765/A		16-Apr-24	Other	20-May-24	879.03

I've opened the original file from PDF, and in the second column, if there are values then I'd like to push the cells to the right.
The order in which the rows appear in either table is not important. The cells are only highlighted for explanation purposes, no formatting is required.

Output:

Invoice	Column3	Date	Ref	Due	Amount	Total
S00255628		15-Apr-24	Text	20-May-24	404.70	404.70
S00255629		15-Apr-24	Text	20-May-24	279.70	279.70
S00254878		28-Mar-24	PAYMENT REF: 00443161	20-Apr-24	479.64	479.64	25,387.81
W00001450		28-Mar-24	PAYMENT REF: 00443246	20-Apr-24	61.80	61.80	25,449.61
W00001484		15-Apr-24	Other	20-May-24	10.80
S00252765/A		16-Apr-24	Other	20-May-24	879.03

 

[alex78]

Hi @danhendo888,

try

= Table.FromRows(List.Transform(Table.ToRows(Source), (x) => if x{1} = null then List.InsertRange(x,List.Count(x), {null}) else List.InsertRange(x,1, {null})),
Table.ColumnNames(Source) & {"Additionnal Column"})

Regards,