SPLIT rows based on new line
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
Still loading...
ABCDEFGHIJKLMNOPQRST
1
InputOutput
2
This is the first item.
This is the second one
Sometimes the items end in a period.
Sometimes they don't
This is the first item.
3
This is item 5
This is item 6
etc.
This is the second one
4
Item 7...Sometimes the items end in a period.
5
Sometimes they don't
6
This is item 5
7
This is item 6
8
etc.
9
Item 7...
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Loading...
 
 
 
Sheet1