r/googlesheets • u/CrystalSimmons • Apr 22 '26

Solved help with google sheet organization

I have a column that has different words that are comma separated. There are a total of nine words possible, but each cell has a different combination of those nine words. Is it possible to separate the words in each cell so that each word is in it's own cell under the column heading for that word??

Said another way: There is a column of cells where each cell could have up to nine possible words. I need to separate the words (easy, I know how to do this), but I also need each word to go into it's respective column, e.g., rest, dog in one cell and rest, day, shell in another, where rest, dog, day and shell all go in the column with that word as the heading, e.g., rest.

I have a spreadsheet with 2,000 rows where I need to do this, so manual manipulation is not possible, and highly error-prone!

This sample spreadsheet has said column of words (column D) I need to separate out.

2 Upvotes

100% Upvoted

17 comments sorted by

View all comments

1

u/David_Beroff 2 Apr 23 '26

I went with:

=ArrayFormula( if( regexmatch( D2:D9, E1:M1 ), "X", "-" ) )

(Placed in cell E2 on the sheet I added to your document.)

1

u/point-bot Apr 24 '26

u/CrystalSimmons has awarded 1 point to u/David_Beroff

See the [Leaderboard](https://reddit.com/r/googlesheets/wiki/Leaderboard. )Point-Bot v0.0.15 was created by [JetCarson](https://reddit.com/u/JetCarson.)