Selecting a row of numbers clockwise around a matrix of values
1 view (last 30 days)
I have an excel file as a matrix of random values (10 rows by 16 columns). I would like to select the value of outer cells, countiniously in clockwise direction (as illustrated in photo starting with cell #1 and ending with cell #17) and paste it as a row of 48 values into a new excel file. My ultimate goal is reading mutiple files in a folder ,and paste the same string row by row in a single excel file.
I appreciate your help and answers for learning and understanding it.