Forum Discussion
BetsabePastrana
Aug 10, 2024Copper Contributor
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...
PeterBartholomew1
Aug 10, 2024Silver Contributor
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.