I have been tearing out what is left of my hair trying to sort data in a spreadsheet. The long and short of it is I have a sheet of data related to member information. Column's A-Z. Column A has case_num and can be listed several times within rows of data.
Many of the lines can have dup information information but I am looking to match column A and if there is any data in column L, concatenate or merge it into column L.
I am not sure what formula or syntax to use. I can provide sample data. Thank you for your help.