I have a small program created to set matrix values after pre-determined patterns assigned to me. The matrix values are printed column by column to a text file (as per instructions given to me). For example, each row in the .txt file sample below would be a column of information:
1,2,3,4,5
4,5,3,5,6
4,5,1,6,9
I wish to import this file to Google Sheets in its actual matrix format so that I can look at the patterns:
1 4 4
2 5 5
3 3 1
4 5 6
5 6 9
I have found google sheets will automatically put this data into rows for me, and then I have found information here about the Transpose function that I can impose manually to change those rows to columns. These matrices will be many and arbitrarily large. Is there a way to automate the transpose?