AT&T Step Processes

No Customization

1. Load list in Excel and check email column for duplicates and remove all duplicates
2. Upload list to TM
3. Export the report of UnSubs (this will create the PreUnSub list

= Last 4 Digits of Ban

1. Load list in Excel and create a new column
2. in the new column you can add in the cell `=RIGHT(B2,4)` (Replace B with the column with the BAN Numbers
3. Use the new column when uploading to TM for the BAN number

Combining Numbers to One line

1. if it is a small amount you can copy and paste
2. for large amounts you might need a formulate similar to below:

`=INDEX($D$2:$F$5, INT((COLUMN()-COLUMN($G$1))/COLUMNS($D$2:$F$5))+1, MOD((COLUMN()-COLUMN($G$1)), COLUMNS($D$2:$F$5))+1)`