In indexed format, each well is written into an individual row. Well ID’s are given in the “A1” style (where the letter indicates the row and the number the column on the plate). Note that the data of interest (the Ct values) are located a certain number of columns to the right of the cell containing the well ID; more on that below.
This is a companion discussion topic for the original entry at https://www.xltoolbox.net/transpose.html