Previous Topic Next Topic

Excel help

Closed
mm - Jul 28, 2010 at 01:52 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jul 30, 2010 at 08:29 AM
Hello,

How do i duplicate rows in excel based on a condition.

e.g.

name count
aa 3
bb 1

i wish to duplicate each name with the number of counts it has.
e.g. for name "aa" , i would like to duplicate it 3 times.
for name "bb", i would like to duplicate it 1 times.
i would not want to manually duplicate as i have 1000 over records.

please share your ideas.
Related:

1 response

Answer 1 / 1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Jul 30, 2010 at 08:29 AM
See this
https://ccm.net/forum/affich-333050-how-to-repeat-rows-by-x-number-of-times
0

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
Date formatting in dd/mm/yyyy
nisha -
appu -

11 responses
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

1 response