Forum Discussion
Terrassa
Helper I
Helper IMove values from pair rows to columns on unpair rows
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?
1 Reply
slorinSuper User
Hi
=Table.FromRows(List.Transform(List.Split(Table.ToRows(Previous_Step),2), List.Combine))
Stéphane