Excel help

Closed
mm - Jul 28, 2010 at 01:52 AM
rizvisa1
Posts
4479
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.

1 reply

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
770
Jul 30, 2010 at 08:29 AM
0