Formula Help - Duplication

[jamescooper]

Hello, If everytime there is a blank in column B, I want to produce 2 entries for the column A, how would I do this in a formula please?

Thanks.

CARMARTHN		O
CARMARTJN		P
FERRYSIDE		P
KIDWELLY		P
PEMBREYBP
LLANELLI
LLANDILOJ		P

<colgroup><col><col span="2"></colgroup><tbody>
</tbody>

 

[Special-K99]

So to clarify things what would your output look like?

 

[jamescooper]

CARMARTHN

CARMARTJN

FERRYSIDE

KIDWELLY

PEMBREYBP

PEMBREYBP

LLANELLI

LLANELLI

LLANDILOJ

<colgroup><col width="64" style="width:48pt"> </colgroup><tbody>
</tbody>

 

[jamescooper]

Any ideas here please?

Many thanks.

 

[jamescooper]

Any ideas? Thanks

 

[jamescooper]

No ideas ?

 

[Special-K99]

I got this, just done something very similare somewhere else, give me a few mins...

 

[Special-K99]

in the same Sheet

insert a column so the CARMARTHN column is column B, and the Os and Ps are column C

in D1 put
=IF(C1<>"",1,2)
and copy down to D7

in A1 put 1
in A2 put =A1+D1
and copy down to A7

in E1
=IF(ROW()>SUM(D$1:D$7),"",ROW())
and copy down, make sure you drag it enough to cover the total entries in this case 9

in column F
=IFERROR(VLOOKUP(E1,$A$1:$B$7,2),"")
and copy down, make sure you drag it enough to cover the total entries in this case 9

You should now have a list of the towns as you want.