I would like to use this formula "=ConcatUF(times!B7:B16,";",FALSE,FALSE)"
in the table below.
ColA ColB ColC
Row1 Time A B
Row2 10:30:00 AM
Row3 9:30:00 AM
My data table is setup like this:
ColA ColB ColC
Row1 Time A B
Row2 9:30:00 AM E1 GG
Row3 9:30:00 AM Y0 D1
Row4 10:30:00 AM U4 Q1
Can the formula be modified to perform the concatenation like this:
ColA ColB ColC
Row1 Time A B
Row2 10:30:00 AM U4 Q1
Row3 9:30:00 AM E1;Y0 D1;Q1
Thank you in advance.
Bookmarks