A B C
1 dog pig
2 mo doe sak
3 fad fud dud
I have a matrix chart like the one above, the desired out though is a 3-column table like below:
mo dog doe
mo pig sak
fas dog fud
fad pig dud
However, in this formula, I would like to include column D and E and rows 4 and 5 even if they are blank so that the 3-column table can automatically update itself (if possible, those cells will stay blank until D, E, 4 and 5 have something in them. Any help is appreciated!! Thanks
Bookmarks