Forum Discussion
EddieC1974
Dec 30, 2024Copper Contributor
Which Formula do I need?
I have a spreadsheet that has 5 columns of data but there is only going to be 1 answer in a column in any row, I am going to create an additional column, what I need is this column to show the answer...
Patrick2788
Dec 31, 2024Silver Contributor
If you're working in a fully updated Excel 365 then it's very simple:
=BYROW(data,CONCAT)