Problem managing big table in Excel - (Dec/09/2018 )

Dear all, 

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 ? 

Excel is really not set up to do this sort of thing at all. Large data analysis is very difficult in excel, but R excels (pun intended) at it

You should be able to use the file in R - use as a minimum:

>install.packages("readxl")

>library(readxl)

>your_data <- read_excel("path\to\your\file.xlsx") 

Check out ?read_excel (or google it) if you want more information.

Transposing in R is quite simple - it's part of the base R packages, so should be already installed - have a look at the syntax using ?t in your R terminal/console. You may need to make your dataframe into a matrix:

>your_matrix <- as.matrix(your_data)

>transposed <- t(your_matrix)