I have a big table in excel which contains 20 column and 93.000 rows. Now I can open the file as this is within the limit of excel. I would like to run a PCA plot using R program. This requires me to transpose this table meaning that I will contain 20 row and 93.00 column which is not possible in excel.
Has any of you an idea to transpose this table using excel (by surpasing the limit) or by other program ?
I was able to do this in R, but again you can not export the excel file to R, ans it gives an error message.
Any help ?