which formula?

[hldemirkaya]

SOURCE TABLE
TURKEY ANKARA
TURKEY ISTANBUL
TURKEY IZMIR
USA NEW YORK
USA WASHINGTON

which formula can i use to obtain a table as below?

TURKEY ANKARA - ISTANBUL - IZMIR
USA NEW YORK - WASHINGTON

ANOTHER SAMPLE:
SOURCE TABLE
A 1
A 16
A 45
B 12
B 80

TARGET TABLE
A 1 - 16 - 45
B 12 -80

Thank you very much for your attentions.

 

[BrianB]

I cannot fully understand what you want.

With strings (text) we can concatenate them (join them together) so

You can have a formula like
=A1 &" - " &B1 &" - " &C1

or, to do the same thing
=CONCATENATE(A1," - ",B1," - ",C1)

You will see that cell references look like A1,B1,C1
Other text needs quotation character either side eg."text"

In the absence of another reply, and seeing this is your first message .........
If you do not receive a reply to your message after a couple of days you can reply to your own message (some just put "bump") to bring it to the top again.
You may think about changing it (we may not fully understand what you want).

If you put code in your message you would need to have some comments in it to say what you are trying to achieve and FORMAT IT CORRECTLY.

Our time is limited and some messages have too many questions, are not clear about what is wanted, or are just not readable.
My reply will now bring your message to the top again, so someone else may be able to help.

 

[Aladin Akyurek]

Do you want ANKARA - ISTANBUL - IZMIR in a single cell or in cells of their own?

 

[hardeep.kanwar]

Do you want ANKARA - ISTANBUL - IZMIR in a single cell or in cells of their own?

I am Facing Same Problem

Example

Excel Workbook
	A	B	C	D	E	F	G	H	I
1	name	Location				Expected Result
2	Hardeep	Delhi				Hardeep	Delhi	Noida	Gurgaon
3	Hardeep	Noida				Pardeep	Kanpur	Varanasi
4	Hardeep	Gurgaon				Neeraj	Bangalore	Chennai
5	Pardeep	Kanpur
6	Pardeep	Varanasi
7	Neeraj	Bangalore
8	Neeraj	Chennai
Sheet1

Excel 2007

Regards

 

[LearnMeExcel]

May be this will help

Excel Workbook
	A	B	C	D	E	F	G	H	I
1	name	Location				Expected Result
2	Hardeep	Delhi				Hardeep	Delhi	Noida	Gurgaon
3	Hardeep	Noida				Pardeep	Kanpur	Varanasi
4	Hardeep	Gurgaon				Neeraj	Bangalore	Chennai
5	Pardeep	Kanpur
6	Pardeep	Varanasi
7	Neeraj	Bangalore
8	Neeraj	Chennai
Sheet1

Excel 2010

#VALUE!

Entered with Ctrl+Shift+Enter. If entered correctly, Excel will surround with curly braces {}. Note: Do not try and enter these manually yourself

 

[hardeep.kanwar]

May be this will help

Excel Workbook
	A	B	C	D	E	F	G	H	I
1	name	Location				Expected Result
2	Hardeep	Delhi				Hardeep	Delhi	Noida	Gurgaon
3	Hardeep	Noida				Pardeep	Kanpur	Varanasi
4	Hardeep	Gurgaon				Neeraj	Bangalore	Chennai
5	Pardeep	Kanpur
6	Pardeep	Varanasi
7	Neeraj	Bangalore
8	Neeraj	Chennai
Sheet1

Excel 2010

#VALUE!

Entered with Ctrl+Shift+Enter. If entered correctly, Excel will surround with curly braces {}. Note: Do not try and enter these manually yourself

Wow!!!!!!!!


Thanks

 

[LearnMeExcel]

thanks for Aladin Who learn me all that

 

[hldemirkaya]

thank you very very much.

 

[javalover]

I tried this array formula and only get a return in column G. How do I get column(s) H, I, etc. to populate?

(AND, what is the purpose of "SMALL" in this formula? I tried switching it to "LARGE" and got the return of the row below.)

thanks for your help! still baffled...

 

[Aladin Akyurek]

I tried this array formula and only get a return in column G. How do I get column(s) H, I, etc. to populate?

(AND, what is the purpose of "SMALL" in this formula? I tried switching it to "LARGE" and got the return of the row below.)

thanks for your help! still baffled...

SMALL is there to return the row numbers...

Care to post a small sample along with the desired results?