Forum Discussion
Transpose columns to rows between two files with Tanspose formula
I have type the formula =TRANSPOSE([MT_Line.Flow.csv]MT_Line.Flow!$JR$2:$JR$37) "File name and sheet name is the same in the origin file" I feel that Excel works with that fo...
I've found a solution. I had a table format and this may affect the formula. I copied the formula in other sheet with no format and the data are shown as I wanted. Thanks