How to split cells to multiple cells based on values given in corresponding cells.

Occasional Visitor


I want to split cells in 1 column, based on corresponding numerical values given in another column. So if, lets say, A1 has "5", I want B1 to be broken up in to 5 cells in 5 rows. Is that possible using formula or Macros?

0 Replies