I need a macro help !!! to move data from column according to a same ID

[petitesouris]

Hi,

I have a list with 4000 records for student and we would like to only keep the unique student ID but bring acrross into one line records

I have attached a sample file I get things but not what I really whelp.xlsxhelp.xlsxant and your expertise would be welcome

[FDibbins]

Try this...
1. Delete the data you have in Sheet3 (leave the headings)
2. Put this in A2, copied down...
=IFERROR(INDEX(Sheet1!$A$2:$A$19,MATCH(0,INDEX(COUNTIF($A$1:$A1,Sheet1!$A$2:$A$19),0,0),0)),"")
3. Put this in B2, and copy down and across...
=IF(A2="","",INDEX(Sheet1!$A$2:$K$19,MATCH(Sheet3!$A2,Sheet1!$A$2:$A$19,0),MATCH(Sheet3!B$1,Sheet1!$A$1:$K$1,0)))

[petitesouris]

Thank your very much I did finally find a macro that I was able to work on what I wanted to achieved but this is something I need to explore as well the formula. Thank you so much for your quick reply.

[petitesouris]

How do I mark solved ?