I have almost one million numbers of rows and I'd like to transpose them in columns, but since the limit of columns is way lower than that, I was wondering if it's possible to go around this problem and continue pasting in the next sheets automatically, until all the rows are transposed.
I know that maybe it's not the best way to handle such an amount of columns, but I don't know very much about SQL and using databases, I would appreciate any advice on basic guides that cover what I need to know for this situation though.
Thank you in advance.
Bookmarks