Repeat a row multiple times

Hi,

This is clearly a much simplified example and probably doesn't represent the size of your actual data. We often find that when we give an answer to what is a trivial non representative example when the solution is used with the real world data it doesn't work because of factors like string length and other stuff which is important but hasn't been mentioned.

Therefore upload your real workbook (or at least a cut down copy), and manually add the results you expect to see. Clearly identify which is original data and which are the results and in a note clearly explain how you have arrived at your results.

For instance it's not clear if you want to repeat the data seven times, just once, or seven times say every week. Mention of 7 times suggests these are records that reflect a day of the week. In which case you should really be including a date against each record. Then it may not be necessary to always have 7 records for each name if there is no data on some occasions.

Please try

Please Login or Register  to view this content.

or with LET function

=LET(a,'Current data'!A2:J5,s,SEQUENCE(ROWS(a)*7,,0),b,INDEX(a,INT(s/7)+1,SEQUENCE(,11)),IFERROR(IFERROR(b+MOD(s,7),b),INDEX({"BUS";"Common";"HD";"HD PRO 6000";"LMD";"Parts";"Sub 5T"},MOD(s,7)+1)))

Or (simpler formulae!!)
=IFERROR(INDEX('Current data'!A:A,AGGREGATE(15,6,ROW('Current data'!$A$2:$A$10)/('Current data'!$A$2:$A$10<>""),1+INT((ROWS(A$2:A2)-1)/7))),"")
in a2, copied across and down, then in K2, copied down:


=IF(A2="","",INDEX({"BUS","Common","HD","HD PRO 6000","LMD","Parts","Sub 5T"},1+MOD((ROWS(K$2:K2)-1),7)))