Hi community, i am trying to use Multirow function to fill up the blanks under account name column if the the account no. column is the same as the previous line.
Data:
Account No. Account Name
0102-000-0 cash
0102-000-0 [blank]
0102-000-0 [blank]
0102-000-0 [blank]
0102-001-0 [blank]
0102-001-0 bank
0102-001-0 [blank]
0102-001-0 [blank]
0102-001-0 [blank]
0102-001-0 [blank]
So the result should look like:
Account No. Account Name
0102-000-0 cash
0102-000-0 cash
0102-000-0 cash
0102-000-0 cash
0102-001-0 [blank]
0102-001-0 bank
0102-001-0 bank
0102-001-0 bank
0102-001-0 bank
0102-001-0 bank
i can leave that blank under account name as is because i can just use multirow later on again, i'm just having trouble figuring out how to multirow account name only if the account no. is the same as previous row.
