How can i transform this Address portion for "clean data" in Power Query Editor? I want to put the Apartment #$\text{'}$s after thr address, as well as the PO Box

Table$1-$ Power Query Editor

Queries $[2]$

Table $1$

Table$1(2)$

$\backslash$table$[[,,f_x,=$ Table.ReplaceValue$($#"Trimmed Te$],[,,A^{B}C$ Address$1*,,A^{8}C$ City$*],[1,,230$ W COLEMAN,Rice Lake$],[2,,$P$.$O$.$ Box $573,6734$ Pellentesque, Rd$.,$Provo$],[3,,9890$ Nibh. Road,Anchorage$],[4,,$Ap H$361-2823$ Ac$,$ Road,Honolulu$],[5,,7389$ Auctor Rd$.,$Lafayette$],[6,,6953$ Blandit. Street,Iqaluit$],[7,,3936$ Sit Road,Burin$],[8,,430-3279$ Ornare Av$.,$Indianapolis$],[9,,$Ap #$372-8571$ Massa. Av$.,$Waterbury$],[10,,154-8362$ Laoreet Rd$.,$Holman$],[11,,184-4703$ Scelerisque St$.,$Topeka$],[12,,,,$null,Pangnirtung$],[13,,$P$.$O$.$ Box $384,$Knoxville$],[14,,$Ap #$674-6824$ Bibendum Avenue,Bozeman$],[15,,$Ap #$964-1299$ Eu$,$ St$.,$Prince Alber$],[16,,819-5402$ Maecenas Rd$.,$Lourdes$],[17,,575-5891$ Nullam Av$.,$Guysboroug$],[18,,322-9711$ Ligula Rd$.,$Fogo$],[19,,$Ap #$819-4455$ Urna Avenue,Vilina$],[20,,8870$ Erat Rd$.,$Millet$],[21,,140-2552$ A Road,Wabamun$],[22,,$Ap #$819-7889$ Cras Ave,Rigolet$],[23,,766$ Proin Street,lowa City$],[24,,$Ap #$212-9985$ Lacus, Rd$.,$Lanark Cour