User537843Copper ContributorJan 13, 2022How to transpose and skip? Hello everyone, thanks for being so helpful. I have columns where I need to transpose them into rows. I need to copy only every 6th column in the source, but not skip cells in the row destinat...Show More
SergeiBaklanDiamond ContributorJan 13, 2022User537843 As variant =INDEX( range, 1, SEQUENCE( INT( COLUMNS( range )/6) + 1, ,1, 6 ) )
