Shift Data after column down to a new row

[roncruiser]

On specific rows of my data set, I would like to move a row of text after a specific column to a new row down.

Much like a carriage return would do.  My power query creativity is very low today.

Thank you...

For example:

Would like to move the data after the arrow to a new row.

RAW data csv.  From this....

...to this in Power Query (new row)

Move data to new row.

Stuck here.

[Vvelarde]

@roncruiser 

Hi, i'm sure that exist another way but i will do thiw:

Duplicate the Query

Filter Rows that contain max_eyew in Column 9

Remove other Columns (1 to 😎

Rename the column names (1 to 😎

Append to Original Query

Regards

Victor

[roncruiser]

That trick row occurs in multiple places in the data set.

If it happened only once, your solution would work, but 

that trick row happens 16 separate times.

...