Copy cells from column A to column C, x times (with x as variable in Column B). Easy formula?

Question

Is there an easy formula to copy&nbsp;cells from column A to column C, x times (with x as variable in Column B). Easy formula?8.B&nbsp; &nbsp; 3&nbsp; &nbsp; 8.B4.C&nbsp; &nbsp; 1&nbsp; &nbsp; 8.B1.A&nbsp; &nbsp; 2&nbsp; &nbsp; 8.B&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;4.C&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1.A&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1.A

sergeibaklan · Answer

EmilyAnn_55-55&nbsp;
Please check an answer here&nbsp;https://answers.microsoft.com/en-us/msoffice/forum/all/how-to-repeat-text-n-times-in-excel-2010/4059fc11-f819-43b5-91c0-41435e3a4bfe?auth=1

emilyann_55-55 · Answer

That is AWESOME! Thank you Sergei Baklan (MVP)! An answer within an hour!

sergeibaklan · Answer

EmilyAnn_55-55&nbsp;, you are welcome

Forum Discussion

Copy cells from column A to column C, x times (with x as variable in Column B). Easy formula?

3 Replies

Resources