Multi-row

[Ashley]

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.

[caltang]

Just want to confirm - since 0102-001-0 has Bank in the 2nd row, you only want rows after a non-null Account Name to show? The one previously is left Null as is? 

[Qiu · Accepted solution]

@Ashley 
I share the same clarification but just a quick sample to replicate your provided output.