Forum Discussion
Converting outputs from 96 well plate reader from list to matrix
Hello, I am using a 96 well plate reader which outputs data as a list of samples that correlate to a row value and a column value. A simplified version of what it puts out looks like this: Wh...
... and if you are fortunate enough to be using 365 or Excel 2021
= LET(
k, TRANSPOSE(SEQUENCE(3,8)),
INDEX(Sample,k))will do the job.
- What is the formula for an opposite task?
Things have moved on since this post. The basis for the solution above would now be
= WRAPCOLS(Sample, 8, "")and the reverse is
= TOCOL(matrix,,1)
