Here is a minimal example:
\documentclass{article}
\usepackage{pgfplotstable}
\begin{document}
\pgfplotstableread[col sep=comma]{
x1, 1.2405, 1.8201, -0.0102, 1.3856, 1.1426, 0.4152
y1, 2.3087, 1.9424, 1.7771, 1.9353, 2.1254, 1.6762
}{\mytable}
Original table:
\pgfplotstabletypeset[string type]{\mytable}
\bigskip
\pgfplotstabletranspose{\mynewtable}{\mytable}
Transposed table:
\pgfplotstabletypeset[string type]{\mynewtable}
\end{document}
How do I get x1 and y1 to be the column names in the transposed table? That column in the original table doesn't have a name, but I know it's the first column. Is there a way I can just point to that index? Thanks.