1
00:00:00,080 --> 00:00:04,166
A fictional task export puts AUDIT, REVIEW, and SHIP into one

2
00:00:04,166 --> 00:00:05,652
cell separated by commas.

3
00:00:05,652 --> 00:00:09,738
The data needs one tag per row for a vertical checklist.

4
00:00:09,738 --> 00:00:13,824
The usual Split text to columns command would spread them across

5
00:00:13,824 --> 00:00:17,910
the page, so we will combine SPLIT with TRANSPOSE and verify

6
00:00:17,910 --> 00:00:19,395
the three exact outputs.

7
00:00:19,995 --> 00:00:24,252
Open the practice CSV in a disposable Google Sheet and read

8
00:00:24,252 --> 00:00:29,283
A2 exactly: AUDIT comma REVIEW comma SHIP, with no spaces after the commas.

9
00:00:29,283 --> 00:00:34,313
This detail matters because the simple formula below does not trim surrounding spaces.

10
00:00:34,313 --> 00:00:38,957
Leave A2 in place so the result remains linked to the source.

11
00:00:38,957 --> 00:00:42,439
Clear C2 through C4 before entering an array formula.

12
00:00:43,039 --> 00:00:47,425
SPLIT separates the source text around each comma and returns a

13
00:00:47,425 --> 00:00:49,419
horizontal row of three values.

14
00:00:49,419 --> 00:00:52,608
TRANSPOSE switches that row into a vertical column.

15
00:00:52,608 --> 00:00:54,602
Google documents both functions separately.

16
00:00:54,602 --> 00:00:58,987
In this lesson, the nested formula is simpler than moving cells

17
00:00:58,987 --> 00:01:04,171
by hand, and any edit to A2 should recalculate the three visible outputs.

18
00:01:04,771 --> 00:01:10,380
Select C2 and type the formula exactly as shown for a U.S. formula locale.

19
00:01:10,380 --> 00:01:14,868
Press Enter and look for a three-cell spill down column C.

20
00:01:14,868 --> 00:01:18,982
If Sheets reports that the array cannot expand, clear the destination

21
00:01:18,982 --> 00:01:22,722
cells in a disposable copy rather than overwriting unrelated data.

22
00:01:22,722 --> 00:01:27,958
Do not drag the formula down three times; one formula creates the full list.

23
00:01:28,558 --> 00:01:33,583
C2 should say AUDIT, C3 should say REVIEW, and C4 should say SHIP.

24
00:01:33,583 --> 00:01:37,834
Check the order as well as the count; a vertical list

25
00:01:37,834 --> 00:01:40,926
is only useful if the original sequence survives.

26
00:01:40,926 --> 00:01:44,791
The original A2 stays as one comma-separated text value.

27
00:01:44,791 --> 00:01:49,816
The result is three values, not three independently editable copies of the source.

28
00:01:50,416 --> 00:01:54,478
If a source cell contains spaces after commas, blank items, or

29
00:01:54,478 --> 00:02:00,018
several rows of comma lists, do not assume this one-cell example handles those cases.

30
00:02:00,018 --> 00:02:04,080
Inspect the text, choose a cleanup step appropriate to it, and

31
00:02:04,080 --> 00:02:05,558
independently check the result.

32
00:02:05,558 --> 00:02:09,989
The companion answer shows the exact no-space example, so the tutorial

33
00:02:09,989 --> 00:02:12,944
makes a narrow claim that can be reproduced.