Forum Discussion
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 from the 5 other columns.
Any suggestions welcome.
Cheers
2 Replies
If you're working in a fully updated Excel 365 then it's very simple:
=BYROW(data,CONCAT)Let's say the answers are in columns D to H, starting in row 2.
In another cell in row 2:
If the answers are numbers or dates: =SUM(D2:H2) or =MAX(D2:H2)
If the answers are text: =CONCAT(D2:H2)
Fill down.
