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

Hi,

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?