Splitting semi-colon delineated integers across an array into a single column

[EmLearnsMicrosoft]

Hello. I have data in a large array that I'd like to be extracted into a single column, with each unique value having its own cell. All of the data are 8-digit integers that appear throughout multiple columns and rows. Some of the cells contain multiple 8-digit integers, which are delineated by "; ". A large portion of the cells are empty, and I'd like those cells to be ignored. I need help writing a formula in Excel for Mac that can extract each unique 8-digit integer into its own cell in a single column. Please see my example below. (I have color-coordinated the cells and the text in the source cells as well as in the "Desired Output" column to make it easier to track where each output value came from in the source array.

Copy of JW_Univ Flu Vaccine.xlsx
	A	B	C	D	E	F	G	H	I	J
1	ExCol1	ExCol2	ExCol3	ExCol4	ExCol5	ExCol6	ExCol7	ExCol8		Desired Output
2	34209093; 33535408; 33153089	34209093; 33535408; 33153089	34209093; 33535408							34209093
3	34603333	34603333								33535408
4	35914365; 34929590; 33603072; 32882637; 29107058	35914365; 34929590; 33603072; 32882637; 29107058					19726355			33153089
5	35788567; 35869290; 36281705	35788567								33535408
6	38328128	38328128								34603333
7	37308364	37308364			36789849					35914365
8	36992230; 26061265	36992230; 26061265; 66358721						99856402		34929590
9	78510236; 11200659; 30001425	78510236; 40062358								33603072
10										32882637
11										29107058
12										19726355
13										35788567
14										35869290
15										36281705
16										38328128
17										37308364
18										36789849
19										36992230
20										26061265
21										66358721
22										99856402
23										78510236
24										11200659
25										30001425
26										40062358
Sheet3

 

[SunnyAlv]

try

=TRIM(UNIQUE(TEXTSPLIT(TEXTJOIN(";",,TOCOL(A2:H9,3)),,";")))