Unpivot Repeating arrays

[adamsc]

Hello all,

I have a sheet with several 'Boxes' of information side by side. Each 'Box' corresponds to a certain label. This particular sheet has 23 of these boxes

I want to use power query or some other means to get those boxes stacked vertically instead of horizontally.

Using Transpose in excel doesn't work. I'm also open to using formulas. I tried to use offset but found it too cumbersome.

Example

Input;

Desired Output:

Is this achievable? I think of the unpivot action, but I don't know how that would work here, exactly.

Any help is appreciated!

 

[Sam_D_Ben]

Try scripting -

 

[adamsc]

Try scripting -
View attachment 90549

Thanks. I was hoping to be able to do this without reverting to scripting (like in power query), but this honestly might be the best bet.

If anyone else can think of a Power Query manipulation to do the same thing, you are still welcome to reply. I'll leave the thread open.