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á!
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á!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks