Is Power query able to do this data transformation ?

[Lolo]

Hello,

I have a data transformation that I'm able to do in VBA, but I'm wondering how I could do that in power query. It is a transpose action but with a conditional break.

Basic example, I have this set of data
Vehicule Voyage Point date1
VE1 VO1 FRMRS 01/01/2017
VE1 VO1 FRLIO 02/01/2017
VE2 VO2 FRFOS 04/01/2017
VE2 VO2 FRMRS 05/01/2017


I want to transpose it, like below.
When the vehicule changes ,the transpose stops and continue, but at the next available line
VE1 VE1
VO1 VO1
FRMRS FRLIO
01/01/2017 02/01/2017
VE2 VE2
VO2 VO2
FRFOS FRMRS

01/01/2017 05/01/2017​

Is it possible to do that in power query ?

Attached, the sample file.
thank you !

 

[Chihiro]

While it is possible, this sort of operation isn't meant for PowerQuery.

In database engine based analysis/transformation tools, you don't want column with mixed data types.

This sort of operation is best left to VBA/Formula etc.

 

[Lolo]

You're right !
The goal is to transform data but for an output I would say, not for transform data to be reused.

Thank you.