Merging Column in Excel

[Nani520]

Hi, appreciate if someone can assist me on the below.
I would like to merge multiple columns into 1 single column (Ref) under same person (Name).
Does anyone know of way to make this happen?
Any help is greatly appreciated!

 

[alansidman]

With Power Pivot

Book6
	A	B	C	D	E	F	G	H	I	J	K
6	No	Name	Amount	Ref	Action		No	Name	Amount	Action	Refs
7	1	Ali	50	123456	play		1	Ali	50	play	123456
8	2	Yeng	20	456789	dream		2	Yeng	20	dream	456789, 528963
9	2	Yeng	20	528963	dream		3	Poo	30	loop	365289, 659741, 236985
10	3	Poo	30	365289	loop		4	Lu	40	hug	625233
11	3	Poo	30	659741	loop
12	3	Poo	30	236985	loop
13	4	Lu	40	625233	hug
14
Sheet1

Look at this link on how to do this in Power Pivot

IMA Site Maintenance

 

[alansidman]

I Have revised this solution by creating a new measure for the Actions

Book6
	G	H	I	J	K
6	No	Name	Amount	Refs	Actions
7	1	Ali	50	123456	play
8	2	Yeng	20	456789, 528963	dream
9	3	Poo	30	365289, 659741, 236985	loop
10	4	Lu	40	625233	hug
Sheet1

 

[Nani520]

Thanks for guidance!!! I encountered some problems here. Am I missing something in the formula?

 

[alansidman]

Where you have [Ref], it should be Table1[Ref]

 

[Nani520]

Sorry keep troubling you, not sure why still cant go through.

 

[alansidman]

At this time, I can see nothing wrong. If you would like to upload your file to a third party location like Box.Net or Dropbox.com for further examination and analysis.