I have a spreadsheet with about 60 columns, each containing a number no longer than 3 digits. I need to combined the numbers in each row into one cell with a "|" between each number. I know how to do that and am successful with that part. The complication is that for each row, there will not be a number in every cell, and when the concatenate formula is applied, I need it to "skip" or overlook the empty cells so that I don't end up with double separators with no number in between.

I've inserted or attached an example that shows in Row 1 what I get in column K when I use concatenate and all the cells contain a number. Row 2 is what I am getting when that same formula is applied and NOT every cell contains a number. Row 3 shows what I need the cell in column K to show (which I manually entered for this example). Can someone tell me how to get this result with a formula?

example.jpg