I have a set of data where the data stays the same from column 2 to column 6 for every 5 rows and only the first column changes every 6th row:
Is there a formula or any way other than manually doing this?
I did this manually so far but I need to do this for 27 different values for the first column
New contributor
Srinivas Kari is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.