Insert spaces – revisited

I had earlier posted a solution on inserting spaces between continuous cells in a list. Though the solution works fine for a few items (46 items in the earlier example), it returns a blank for items after that. The solution had comprised of using the formula C1+1/3; where C1=1 and dragging it so that two [...]

Read Full Post »

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 »