Hey All,
I'm looking for a formula that can both transpose and filter, so there's no repeats, one column of data (B4:B38) to the row (B74:Z74). Also I'm in need of another formula that can transfer the data from column (C4:C38) to column (B75:B81) if the data applies, if no then I'd like for it to display a 0. I tried using the transpose command but I cant get it to work. Any help would be much appreciated. Attached is an example of what I'm looking for.
Bookmarks