distribution of values from single cell to multiple cells in single column

Try entering this formula in B5 as in the below example and fill down.

Formula:

Please Login or Register  to view this content.

	A	B
1	1	Apple Grapes Orange Banana
2	2
3	3
4
5	1	Apple
6	2	Grapes
7	3	Orange

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

Originally Posted by Chhabi

That's great ! What took my time was in understanding the fact that the digits are to be entered manually after fill up.

Glad you got something from that.

FYI if you aren't aware of it the digits references can be replaced by ROWS($5:5). Since the digits were already there using them saves the extra function call.