Formula help for text!

[AntBlabby8]

For each row, I have four columns labled Q1, Q2, Q3, Q4 which represents the shipping quarter for each customer. Under the appropriate shipping quarter, I have an alpha identifier (for one of more than a dozen products). The other quarters for that rowis blank. I want to pull all the alpha identifiers under a single column to the Right, regardless of the quarter column its in to start with. What is a formula to take the text in whichever of the four columns it falls into?

Thanks.

 

[Joe4]

Are you on Excel 2016? If so, the TEXTJOIN function handles this nicely.
See: https://www.techonthenet.com/excel/formulas/textjoin.php

Or perhaps something this simple would suffice:

=A1 & B1 & C1 & D1

 

[AntBlabby8]

Are you on Excel 2016? If so, the TEXTJOIN function handles this nicely.
See: https://www.techonthenet.com/excel/formulas/textjoin.php

Or perhaps something this simple would suffice:

=A1 & B1 & C1 & D1

OMG. I've been doing so many complicated things, the obvious escaped me. Indeed, it's that easy!! Thanks nonetheless.