Unraveling a table

Here is the problem that I faced         I had to extract the entries in the table row-wise and populate this in a single column. Here is one way of doing this: Enter A8=OFFSET($A$2,INT((ROW()-ROW($B$8))/5),MOD((ROW()-ROW$B$8)),5),1,1) Drag down till the entire table is unravelled. What if we had to unravel the table column wise [...]

Read Full Post »