Hi,
Below is my formula in my Description column and next is the result.
The thing here is, Linenbr 1-8 is actually one item with split 8 Serial Numbers (one is blank), that’s why at 8th line, it’s just a sTranDesc]. About the Linenbr 9, it is same inventory as the 1st but it’s another line and ext. cost. It is ok not to specify the description since its the same above and that’s what my formula dictates. My concerns are:
(1) How do I display 1-8 as one Line only and (2) since the last SN is empty, I don’t need the desc to display (I know it contradicts the formula, but is there another way?)
Thanks!