Convert data from columns to rows with M code

This errors out here for me:

Subscript out of range
a = .[b2].CurrentRegion.Value

with the table selected or not

Impossible...

That worked perfectly.
I will review the code and try to learn.
Thank you SO MUCH.

Originally Posted by JewelDarby

I get a Type Mismatch error

As no issue with your attachment on my side …