CONCATENATE formula

[phillyd023]

is there a way to automate a cell to count the number of cells with content and group them all separated by a | symbol?

for example, in the attachment i want the formula in cell AA. i already put the end result i want to see in Cell. i have done this by manually concatenateing all the cells manually but sometimes i get a result like 1|2|3|4|5|6|7||||||||||||||||||||||||||||. my meager result has all the extra |.