CODEWITHSUNDEEP
openrefine
eben.english
eben.english

Reputation: 1675

Open Refine / Google Refine - edit cells in multiple columns

Does anyone know of a way to edit cells in multiple columns in Open Refine using a single command/action?

I have a project with about 75 columns, and I need to apply the same actions to all the cells in each column.

For example, I need to:

Edit cells > Join multi-valued cells

On every column in the project. Hopefully I don't have to do this manually for every column one by one?

Upvotes: 1

Views: 570

Answers (1)

rahi
rahi

Reputation: 126

One approach might be to 'Transpose cells across columns into rows'.

Then you can make the edits from a column, and when you're done, 'Transpose cells in rows into columns.

Here's an article that shows you how to go about transposing columns.

Upvotes: 1

Related Questions