I want to bring data in column 2 in column3 column 4 etc based on Column 1 If A1 not equal A2 Goto A2.
If A1 equals A2 .Then concatenate B2 to B1 delete 2nd row and Goto next row.
Now if A2 equals A3.Then concatenate B2 to B1.delete 2nd row Goto next row.
Do this until A2 not equal A2

Column 1 Column 2
ACCOUNT_NAMEINFO_T LAST_CANON
ACCOUNT_NAMEINFO_T LAST_CANON
ACCOUNT_NAMEINFO_T OBJ_ID0
ACCOUNT_NAMEINFO_T OBJ_ID0
ACCOUNT_NAMEINFO_T REC_ID
ACCOUNT_NAMEINFO_T REC_ID


Can someone help me a macro for this.I am new to excel macros.