Hello all, hope you are well!
My problem:
I have a mastersheet which uses TRANSPOSE() as an array function to return values from another workbook. The transpose has an INDIRECT in it so it knows which file t look at and which sheet within that file it should look at.
The issue is that, unlike paste special > transpose, TRANSPOSE returns blank cells as 0. The data it is looking at contains both blank cells and 0s, so I want to be able to return both. I tried an IF(ISBLANK()) but couldn't get this to work in the array.
Two spreadsheets are attached. I am not tied to TRANSPOSE so anything you think would work would be great.
Thanks,
Tom
Bookmarks