Type - A
Dept: Billing
1.23
Type - A
Dept: Receivables
1.45
Type - A
Dept: Retail
1.67
Type - A
Dept: Publishing
1.01
Type - A
Dept: Adverstising
1.89
Type - B
Dept: Billing
2.01
Type - B
Dept: Receivables
2.23
Type - B
Dept: Retail
2.45
Type - B
Dept: Publishing
2.89
Type - B
Dept: Adverstising
2.67
Type - C
Dept: Billing
3.67
Type - C
Dept: Receivables
3.89
Type - C
Dept: Retail
3.01
Type - C
Dept: Publishing
3.23
Type - C
Dept: Adverstising
2.45
FirstRow
Warn
Warning
All
ByName
#1
#2
Unique: Dept Name
Dept Name2=REGEX_Replace([Dept Name], '[:\s]', '_')
,
Horizontal
OriginalHeaderNames