Transpose ROWS ⇄ COLUMNS (subroutine)

A subroutine and a macro to test it with.

Where left unspecified, the column delimiters – input and output – default to ",".

Unless specified, the row delimiter defaults to "\n".

For example:

NOTE:
All rows need to be of the same length. (Same number of delimited cells).

If any rows are shorter than those that follow, their elements are skipped.

test Macros.kmmacros (8.0 KB)

2 Likes