In Google Docs, you can insert a table, right-click a cell, select "Split cell", specify into how many columns (and / or rows) you want to subdivide the cell, and click "Split" to subdivide a cell. Is there a way to do the same thing in Google Sheets?
I would love this feature in Sheets, but as far as I can tell it's not possible, and I instead have to do a cumbersome combination of "Insert 1 column right", then merge other cells, readjust column width, fix broken formulas, etc. Pain! Splitting a cell into two columns and having all the other cells in that column automatically merge and span the two columns would be very useful. Any tips?
Here's an example in Google Docs: https://workspaceupdates.googleblog.com/2022/10/split-table-cells-in-google-docs.html
Note: I'm NOT after splitting the content, as can be done via Data menu > Split text into columns, or using the SPLIT() formula.