Excel help

[Closed]
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
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

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768