Ask Your Question

Is there anyway to split a multiline cell into rows

asked 2017-07-27 22:17:47 +0200

Consider the following table (copied from a paper):

example table

The highlighted row is actually three rows, but column D is shared, and so the study authors have merged the three rows into one.

I would like to split this into three separate rows, just splitting on the newline. Is there any way to do this?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2017-07-27 22:51:42 +0200

m.a.riosv gravatar image

Menu/Data/Text to column, can help but it overwrites the next rows if not include on the selection. And only for one column at once.

edit flag offensive delete link more


Great, thanks! That does work, it is a little slow but it is way faster than doing it manually :-)

Mike Dacre gravatar imageMike Dacre ( 2017-07-28 00:09:04 +0200 )edit

I noticed that the interface of this menu is the same as text import, which made me realize that this can be done with a text editor: just copy the columns one at a time and remove the quotes, then paste them as new columns. You have to manually handle the repeated rows (such as column D in my example), but you have to do that with 'Text to Column' also.

Mike Dacre gravatar imageMike Dacre ( 2017-07-28 00:20:48 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-07-27 22:17:47 +0200

Seen: 2,098 times

Last updated: Jul 27 '17