This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Maybe something along the lines of this may help? I'm splitting out the CENTER from CENTERNAME using the filter tool then I create a new field that only looks at the first 5 characters of CENTER. I then transpose that new field so the new field name becomes part of the row. I change the newly transposed field to match the original input (Type) and then union the original to the updated.