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 formula but the data is not showed, please help!
Your analysis is correct. Excel does not support the use of multi-cell spill ranges within tables.
I normal use Tables for input data and dynamic arrays for all calculation.
- The files are in different folder, IDK if that could be an error
- 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
