Forum Discussion
transpose
I have 2 columns. I need to create a new table which displays only the unique cells in column A, but column B broken out into a listed/matched row. Please see example attached (current is table A, I want a way to create Table B). Thank you
5 Replies
That could be
=TEXTJOIN(";",TRUE,IF($A$3:$A$10=$D3,$B$3:$B$10,""))if your version of Excel supports TEXTJOIN(). Please check attached.
SergeiBaklan
Thank you so much. This looks like it should work, but when I tried to copy and paste this formula, it is returning the whole string into F3 rather than just the matched values? This is Office 365That is an array formula entered by Ctrl+Shift+Enter instead of Enter. If only you are not on Insiders builds.
