made a workaround... kinda worked.

fixed the values A$1:J$1 on the first cell's formula
dragged all the way down
copied
paste transpose
search/replace A$1:J$1 for A1:J1 with the whole first row selected.
then just dragged the row down. Voilá!