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!
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! Read More