Help on Transpose the Rows conatining specific words automatically...

Hello neetu in After sheet in B2 copy and paste below
=INDEX(Before!$B$2:$B$500,MATCH(0,INDEX(COUNTIF($B$1:B1,Before!$B$2:$B$500),0),0)) and drag down

in AFter sheet A2 copy and paste below and drag down
=IFERROR(INDEX(Before!$A$2:$A$500,MATCH(Sheet1!B2,Before!$B$2:$B$500,0)),"")

for amount in C2 copy paste below
=SUMPRODUCT(--(Before!$B$2:$B$500=Sheet1!B2)*(Before!$D$2:$D$500)) and drag down

for numbers in D2 to right side copy paste below
=IFERROR(INDEX(Before!$C$2:$C$500,SMALL(IF(Before!$B$2:$B$500=Sheet1!$B2,ROW(Before!$B$2:$B$500)-1),COLUMNS($A$1:A1))),"")
then hold control and shift together and hit enter now release all three keys to make it array formula
Then drag formula down and to the right side.

Click " * " add reputation icon in the bottom left corner of my post if this helps

Thanks Hemesh for the prompt reply... but one thing that I forgot to mention that there is also some data with same customer name but in different dates. How can I solve that. Again sample file is attached herewith for reference.

Hello Find attached !

Neetu Gimme some time I Will go through and Respond You back!

Hello Neetu!
in After sheet at D2 copy paste below
=IFERROR(INDEX(Before!$C$2:$C$500,SMALL(IF(Before!$B$2:$B$500&Before!$A$2:$A$500=After!$B2&After!$A2,ROW(Before!$B$2:$B$500)-1),COLUMNS($A$1:A1))),"")
Hold control and Shift together then hit enter. Now drag down and Drag to the Right