Home > other >  To excel in a row transformation matrix
To excel in a row transformation matrix

Time:09-24

How to set a line of data into matrix form?
First transfer line of data for A list of data, using=OFFSET ($A $1, MOD (COLUMN (A1) - 1100) + (ROW (A1) - 1) * 150 + INT ((COLUMN (A1) - 1)/150) * 15000,) formula to the lower right, the '100' is expressed as lines, '150' is expressed as columns
  • Related