Data manipulation columns to rows

[sunrise06]

I have a data file using columns A through IJ. In columns BG through ID are groups of data (6 columns) that I need moved to rows. For columns BG-BL, BM-BR, BS-BX, etc. I need these columns (30 sets of 6 columns) with the associated row data listed under columns BG-BL. Can this be accomplished with Power Query or does this require a macro?

 

[schwiggiddy]

Depending on the content of the data, you may be able to accomplish this in PQ with the pivot and/or unpivot columns function. You'll end up with more rows, but it'll create a column whose content will be the column names of those you're wanting to pivot. What gives me pause is the fact that you have 30 sets. That'll create a lot of rows, but with judicious use of remove duplicates, I think it's doable.