Multi- Row Formula

[Hi2023]

Hi,

how would I create this? I am stuck

In case of the multiple owners,

• Owner-Sequence-Number will be 1 for Primary owner
• Owner-Sequence-Number will be 2 for Secondary owner/s

IIF(isNull([Row-1:SERIAL #]),1,[Row-1:OWNER-SEQUENCE-NUMBER]+1) as the expression?

use existing field of OWNER SEQUENCE NUMBER?

[binuacs]

@Hi2023 Can you provide an example of what you are exactly looking for? 

[Hi2023]

I have an excel file with 

Pay name        pay adr1           pay adr2             pay adr3

john smith        maria   smith     mandy smith       123 road st

should be 

Pay name     (CREATE)Pay last name   pay adr1           pay adr2             pay adr3

John                         smith                      123 rd st

Maria                       smith                      123 rd st

mandy                       smith                    123 rd st