Help please. I have columns ITEM1, ITEM2, ITEM3. If the ITEMs columns are not blank each ITEM will have a corresponding PART (PART1, PART2, PART3) and a SN (SN1, SN2, SN3). All are text columns. I am attempting to join the text only if the ITEM columns contains a value. SHIPMENT CONTENTS column if where I'd like the concatenated value. I have tried everything I can think of.
=CONCATENATE(IF(ISNOTBLANK([Item1],[Item1],", ",[Part1],", ",[SN1]),IF(ISNOTBLANK([Item2]),[Item2],", ",[Part2],", ",[SN2]))
=IF(Item1<>"",CONCATENATE(Item1,", ",Part1,", ",SN1),""), If(Item2<>"",CONCATENATE("Item1","Part1","SN1"),""))
