Previous Topic Next Topic

Formula to copy 1 cell by number in another

[Solved/Closed]
Report
Posts
4
Registration date
Tuesday July 13, 2010
Status
Member
Last seen
July 14, 2010
 -
Posts
4
Registration date
Tuesday July 13, 2010
Status
Member
Last seen
July 14, 2010
 -
I have a spread sheet with text and numbers in a1 to c1 and then in d1 is a number that i need it copy and pasted by

E.G

Hello 3
Stuff 6
hannah 2

I need 3x hello 6x stuff 2xhannah however in my spread sheet that i need done i have about 3000 records i need this done for

Any one know how to do this.

Hope this makes senses
Related:

2 replies

Answer 1 / 2
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
 768
see this

https://ccm.net/forum/affich-333050-how-to-repeat-rows-by-x-number-of-times
1
Thank you
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2821 users have said thank you to us this month

Report
Posts
4
Registration date
Tuesday July 13, 2010
Status
Member
Last seen
July 14, 2010
unfortunately this doesn't make since to me
Report
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
 768
That's a macro that does 100% exactly what you seek
Report
Posts
4
Registration date
Tuesday July 13, 2010
Status
Member
Last seen
July 14, 2010
Thank you i have figured out how to use this now.
Answer 2 / 2

Hi Tanz,

If I understand you correctly you would like cell D1 to be like this:
Hello Hello Hello Stuff Stuff Stuff Stuff Stuff Stuff hannah hannah

First you need to split your data into two columns. Go to top menu Data > Text to columns (or delimiter) and follow on screen directions.

Now use this formula in D1:
=REPT(A1 & " ",B1) & REPT(A2 & " ",B2) & REPT(A3 & " ",B3)

Is this the result you were looking for?

Best regards,
Trowa
Report
Posts
4
Registration date
Tuesday July 13, 2010
Status
Member
Last seen
July 14, 2010
This is very close to what i need except i need it to be in separate cells
so i need it to be
Hello
hello
hello
Stuff
Stuff
Stuff
Stuff
Stuff
Stuff
Hannah
Hannah
Ask a question