post code on col1 & list of suburbs in col2 - what is the formula

V

varun

"Peo Sjoblom" wrote:

Hi Peo
sorry,it did not
'll review the question - may be u can give me a formula
1. row1 -10 contain same post code number
2. row 1-10 contains names of the various post code
3.can you please help me with a formula where single post code combines all
the suburbs in a cell separated by a formula
4. please note that number of suburbs (text) in a single post code varies
need ur help
thanks

varun
 
P

Peo Sjoblom

Sorry, I don't understand your question, same postcode in all rows?

can you give an example like


postcode sub
postcode sub
postcode sub
postcode sub
postcode sub

--
Regards,

Peo Sjoblom

(No private emails please)
 
Top