合并Google表格上的多个单元格值 [英] Combining multiple cell values on Google Sheets

问题描述

Google表格中是否有任何方法可以自动将单元格从当前格式更改为预期的格式，如以下屏幕截图所示:

Is there any way in Google Sheets to automatically change cells from the current format to intended format like in this screenshot:

推荐答案

=ARRAYFORMULA(REGEXREPLACE(TRIM(SPLIT(TRANSPOSE(SPLIT(
 CONCATENATE(TRANSPOSE(QUERY({"♦"&A1:A&"♠", B1:B&", "}, 
 "select max(Col2) where Col2 is not null group by Col2 pivot Col1", 0))), 
 "♦")), "♠")), ",$", ))

这篇关于合并Google表格上的多个单元格值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！