Replace a term in one column with value in next column

=COUNTIF(A1:A347, "Alabama") | Alaska
=COUNTIF(A1:A347, "Alabama") | Arizona
=COUNTIF(A1:A347, "Alabama") | Arkansas

How can I replace the "Alabama"s in the first column with the "Alaska", "Arizona" and "Arkansas" in the second column such that it becomes

=COUNTIF(A1:A347, "Alaska") | Alaska
=COUNTIF(A1:A347, "Arizona") | Arizona
=COUNTIF(A1:A347, "Arkansas") | Arkansas

I am willing to replace the terms manually, but learning how to do it via a formula would be useful for similar tasks in the near future.

I have attached an Excel file showing Before and After.

Unfortunately, I can't do that for an entire column of states, because I would have to do it for each cell manually. The other cell references can't change, but if I dragged that formula down the column, the other cell references would change in addition to that cell reference. For example, =COUNTIFS(AM1:AM8, "(VOL) Neither/Both equally", E1:E8, F12)/COUNTIFS(E1:E8, F12)*100 would change into =COUNTIFS(AM2:AM9, "(VOL) Neither/Both equally", E2:E9, F13)/COUNTIFS(E2:E9, F13)*100 instead of =COUNTIFS(AM1:AM8, "(VOL) Neither/Both equally", E1:E8, F13)/COUNTIFS(E1:E8, F13)*100
The formula suggested is also incorrect because it references a column in the "After" example instead of the second column in the "Before" example.
I have edited the file to make it more clear.

Thank you so much. I didn't realize you could do that.
I want the "Alabama"s in the first column replaced by whatever's in the corresponding cells in the second column.

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

(Note: this requirement is not optional. As you are new I will post the link fir you today: https://www.excelguru.ca/forums/show...in-next-column.)