Excel/Calc中反向文本分列（多列合并）功能技术咨询

Great question! You’re totally right that most spreadsheet apps have a built-in equivalent to reverse the "Text to Columns" function—it’s just often tucked away under a different name, which is why it’s easy to overlook. Let’s break down where to find it in the most common tools, plus why it feels hidden:

Excel #

• Flash Fill (No Formula, Super Fast): Type one example of your desired merged text (e.g., if you want Column A + ", " + Column B, type Apple, Red in the first empty cell below your data). Select the rest of the empty cells where you want the merged output, then hit Ctrl+E (or go to Home > Fill > Flash Fill). Excel will auto-detect the pattern and fill everything in for you—perfect for simple, quick merges.
• Power Query (For Bulk/Advanced Merges): Select your data range, go to Data > From Table/Range. In the Power Query Editor, highlight the columns you want to merge, then click Transform > Merge Columns. You’ll get a pop-up to pick your delimiter (comma, space, custom text) and name the new column. This is ideal for large datasets since it’s editable later if you need to adjust the delimiter.

Google Sheets #

• Right-Click "Combine Columns": This is probably the most straightforward option. Select the columns you want to merge, right-click, and choose "Combine columns". A dialog box will let you pick your delimiter (space, comma, custom input), decide whether to keep the original columns, and name your new merged column. It’s right there in the context menu—you just have to know to look for it!

LibreOffice Calc #

• Merge Cells with Delimiter: Select your target columns, right-click, and choose "Merge Cells". In the pop-up, check the box for "Merge content", then select your preferred delimiter (space, comma, or custom text). Click OK, and your columns will merge into one with the separator you picked.

Why Does This Feature Feel "Missing"? #

The main issue is that no app labels it "Reverse Text to Columns"—they name it based on the action (e.g., "Combine Columns," "Merge Columns") instead of framing it as the opposite of the split tool. Plus, the menu placement varies by app (right-click vs. Data tab vs. Transform tab), which makes it easy to miss on your first hunt.

All these options let you merge columns without writing tedious concatenation formulas, so you can skip the manual third-column workaround entirely.

内容的提问来源于stack exchange，提问作者Lee Blake