Move values from pair rows to columns on unpair rows

[Terrassa]

I have a system that exports data to a file that is imported into Power Query with this format:

Column1	Column2	Column3	Column4	Column5	Column6
a	b	c
d	e	f
g	h	i
j	k	l
m	n	o
p	q	r

The values of pair rows must be in columns 4, 5 and 6 of the unpair columns. The results should be something like this:

Column1	Column2	Column3	Column4	Column5	Column6
a	b	c	d	e	f
g	h	i	j	k	l
m	n	o	p	q	r

Is there any way to do this transformation in Power Query?

[slorin]

Hi

=Table.FromRows(List.Transform(List.Split(Table.ToRows(Previous_Step),2), List.Combine))

Stéphane