ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
Log in to OGD.
23
Click Reports at the top menu.
24
Click Export Specific Fields.
25
Select these fields as shown here.
26
Click Export. This generates and downloads a CSV file to your Downloads folder.
27
Open the CSV file. The file name has this pattern "CFC_SpecificFields_yyyymmdd.csv", where yyyymmdd is the date when you generated the report.
28
29
Using this Excel file (not the above CSV file):
30
Click the Temp sheet/tab.
31
Delete all the contents of the Temp sheet/tab.
32
Copy the contents of the CSV file and paste them into the Temp sheet.
33
Use the "Text to Columns" function for the Chapter name to split it into 3 columns -- Area, Cluster, Chapter.
34
If you do not know how to do this, check this reference:
https://support.microsoft.com/en-us/office/split-text-into-different-columns-with-the-convert-text-to-columns-wizard-30b14928-5550-41f5-97ca-7a3e9c363ed7
35
Copy all the contents of "Temp" to the "OGD" sheet.
36
The Report sheet should auto update.
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