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...
In G2:
=INDEX($A$2:$A$97, MATCH(1, ($B$2:$B$97=$F2)*($C$2:$C$97=G$1), 0))
If you don't have Microsoft 365 or Office 2021, confirm the formula with Ctrl+Shift+Enter.
Then fill down to row 9 and to the right to column R.