I have a excel file of single row,i want to copy it and paste it in rows below for some number of rows, so that a excel file is of many rows of same values of top original row

File of one row is attached here. Iwant it to be 50 rows file of same values

Answer 1

[Jan Kudlacek]

Hi Manu, try this

t = readtable('avg1.xlsx', 'ReadVariableNames', false);
t = repelem(t, 50, 1); % Fill in the rows
writetable(t, 'avg50.xlsx', 'WriteVariableNames', false)

Cheers,

Jan Kudlacek

[Manu Gowda]

Thanku sir It's working