Excel formula to transfer data from one sheet to anoother

[mkbabu26@yahoo.com]

Hi,

I would like to transfer data from one sheet to another with the following caiteria.

Sheet 1
Id Item
1 a
1 b
2 c
3 d
1 e
2 f
Out put sheet want:

1 a b e
2 c f
3 d

Can any one tell me what is the way to do this. What formula I can use here. I am not good in excel. So if
you explain me step by step that might help me.

Thanks.

[AlKey]

Hi and welcome to the forum

***Enter this array formula with Ctrl+Shift+Enter combination in cell E2 , drag formula across then down

=IFERROR(INDEX($B$2:$B$7,SMALL(IF($A$2:$A$7=$D2,ROW($A$2:$A$7)-1,""),COLUMNS($A$1:A1))),"")

	A	B	C	D	E	F	G
1				Unique
2	1	a		1	a	b	e
3	1	b		2	c	f
4	2	c		3	d
5	3	d
6	1	e
7	2	f
8

[mkbabu26@yahoo.com]

Hi,

Thanks for your reply.
I copy your formula and paste it on E2 than press ctrl+shift+enter.
It didn't work.
Can you help me please.

Thanks

[AlKey]

If your setting on the spreadsheet exactly as the one that I provided do this

1. Copy formula and paste it E2 and press ENTER
2. Click on the cell with the formula and press F2 key on your keyboard
3. Now with your left hand press Ctrl and Shift together and while holding them press ENTER.
If you entered formula correctly you will see that your formula is now wrapped around with {} this mean that you've done it right.

Then drag formula across and down.

If you still having a problem you can upload your spreadsheet and I'll do it for you. To upload spreadsheet click on Go Advanced on the bottom of your screen, click on Paper-clip icon, Add Files, select file that needs to be uploaded and click Upload and Done.

If you want me to send a spreadsheet with the formula please let me know.

Regards,

[mkbabu26@yahoo.com]

Sorry as I am new. Still it is not working.

[mkbabu26@yahoo.com]

Sorry still it is not coming. This is not my original spread sheet this is for testing purpose only. Once I been successful than I will do the right spread sheet.

[AlKey]

Nor sure what you question is but here is a workbook attached may this will help you.

[AlKey]

Here is another from one sheet to another where results are on Sheet2