Forum Discussion
Helper VHow Concatenate Text by Category
gomezc73 I posted the formula in the original reply. All you should have to do is replace 'Table' with your actual table name assuming that your columns names are what you posted.
Solution SageWhen you say numbered, what does this number mean? Is it ordered in any particular way? Or represent a rank based on the number of times that explanation occurs?
Helper VHi, it is only a number 1, 2, 3, 4 or a,b,c,d.. it is only to identify that it is a separate explanatations.
By example, the first explanation must be '1', the second explanations must have a '2' etc..
thank you
- CoreyP
Oh, gotcha. Greg_Deckler 's solution is great. For future iterations, if the explanations are not free text, but selected from a list of standard available options, counting their frequency and ranking them might provide some useful insights. Just a thought.