Microsoft office excel repeat value multiple times

Neha Parmar 0

HI All ,

I want to repeat A1 cell value to B1 and then repeat 5 times as shown below in excel.

User's image

1 answer

Olaf Helper 45,371 Reputation points

2024-08-27T18:23:56.6066667+00:00
And what is the problem doing so?

Use formula

=$A$6

for a fix cell address.l
Please sign in to rate this answer.
Neha Parmar 0 Reputation points

2024-08-28T02:12:03.74+00:00

HI Olaf

I have huge data where I want to copy every 1,4,7 and so on raw and paste in B cell based on the count of values.

I dont want to do copy and drag for huge data set
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Your answer