Forum Discussion
concatenate date from duplicate rows into a single field
I have a large spreadsheet containing 4 columns of data. the first three are duplicates, but col4 is not. I am trying to concatenate the 4th column into a single row preserving col 1-3. my attach...
If you have Office 2019 or 2021 or Microsoft 365, enter the following formula in I3:
=TEXTJOIN(", ",TRUE,IF($A$3:$A$17=F3,TEXT($D$3:$D$17,"m/d/yyyy"),""))
If you have Office 2019, confirm with Ctrl+Shift+Enter.
Then fill down.
You can then copy the range as values to another workbook.
- thats not working. BUT, maybe i was not clear. look at my 2 newest files. (what i have AND what i want) thanks
