Last challenge, we converted a matrix into Linear Column. Last time, we picked up values in a row and populated the column and then moved to next row. This time, we have to do exchange row with column. Hence, you need to pick up values from one column and move to the next column and so on.
Suppose you have been given a grid like below. The challenge before you is to write a formula to create a linear column with no blanks in between.
The column ranges would be A to E whereas row ranges would be from 1 to 100. Hence, your formula has to be flexible enough to consider A1:E100 range. (Note – There would be no blanks in between the values in the Grid)
Download the workbook related to this from Challenge 33 – Convert Matrix into Linear Column – II
The solution to this challenge will be published after a month i.e. on 2-Feb-16.