Ask Your Question
0

split single column in to multiple column delimited by empty row

asked 2017-01-21 10:15:38 +0200

E:\jery\english\2002\Lilo & Stitch [2002].mkv ERR066: The SeekPoint at 87 references an unknown Cues at 729107938

E:\jery\english\2002\Tarzan & Jane [2002].mkv ERR066: The SeekPoint at 87 references an unknown Cues at 729579118

E:\jery\english\2002\The Coast Guard [2002].mkv ERR066: The SeekPoint at 87 references an unknown Cues at 727871398

E:\jery\english\2002\The Hunchback of Notre Dame II [2002].mkv ERR066: The SeekPoint at 87 references an unknown Cues at 729328887

E:\jery\english\2002\The Time Machine [2002].mkv ERR066: The SeekPoint at 87 references an unknown Cues at 629013411

this is a single column.i want to split this column to multiple columns.every column starting with the path of movie name and errors in subsequent rows

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2017-01-21 15:04:40 +0200

m.a.riosv gravatar image

Menu/Data/Text to column, use mkv or ERR as delimiter.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2017-01-21 10:15:38 +0200

Seen: 117 times

Last updated: Jan 21 '17