Transpose with Multi Tool

[Hi2023]

Hi, 

little help on how to do the below:

if a Aerial# contains multiple owners then I would need to create a second row with the same sequence # for secondary owner.

then move secondary owner name from Cost address1 to the payee name column

then move the address from cost address 2 column to cost address 1 column

if cost address 3 contians a value and cost address 2 is blank then

move value to cost address 3 to cost address 2 column

after above default cost address 3 to blank

current:

senk   account  aerial#  date recvd  ID           payee name      cost address 1      cost adddress 2     cost address 3

432     12345      5343    1/1/2023    MULT     John Smith        mary smith           123 street              

desired outcome:

senk   account  aerial#  date recvd  ID           payee name      cost address 1      cost adddress 2     cost address 3

432     12345      5343    1/1/2023    MULT     John Smith        mary smith           123 street     

senk   account  aerial#  date recvd  ID           payee name      cost address 1      cost adddress 2     cost address 3

432     12345      5343    1/1/2023    MULT    mary smith        123 street                

thanks!

[binuacs]

@Hi2023 Are you looking for something like the one below?

[mceleavey]

Hi @Hi2023 ,

If you're looking to repeat the header row for each record then you need something a little more complex than simply replacing the values int he rows.

To do this, I've used the Field Info tool to pull the header values into row values, and then a batch macro to apply this for every record.

This identifies those records that have a secondary payee.

This produces the following result:

I've attached the extracted workflow which contains the macro.

I hope this helps,

M.

[Hi2023]

Its giving an error when I try to open

[Hi2023]

So mine is not coming out the same---the outcome is showing cost address 3 having a name in the column?

[Hi2023]

It is also maybe bc some row have adress in address 1, 2, and 3

[mceleavey]

@Hi2023 ,

Mine is coming out exactly as you posted for the data you provided. 

If you have other scenarios can you provide more complex examples so we can provide that?

What is the error you're getting?

M.