2

Say I have 5 cells in column a1:a5 and in b1 I have a multiplier number say 20. How do I copy cell data a1:a5 to appear in the next 20 columns c to v ?

1

2 Answers 2

2

Assuming no version constraints per your tags:

C1: =IFERROR(EXPAND(A1:A5,,B1),A1:A5)

enter image description here

1

This should work for Excel 2021+ onwards using IF()+SEQUENCE():

enter image description here


=IF(SEQUENCE(,B1),A1:A5)

You must log in to answer this question.