Compare cells in column 1 and concatenate values in column 2

**sharmaremuk** · 07-20-2011, 08:25 AM

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.

**JBeaucaire** · 07-20-2011, 11:16 AM

I think this question is more properly suited to the Programming forum.

'COLUMNS TO ROWS
Here's a macro for merging columns of data to one row matching for column A, it's exactly the thing you've described..

Columns to Rows - Part 2

There's a sample sheet there where you can test it out.

**sharmaremuk** · 07-20-2011, 09:04 PM

Originally Posted by JBeaucaire

I think this question is more properly suited to the Programming forum.

'COLUMNS TO ROWS
Here's a macro for merging columns of data to one row matching for column A, it's exactly the thing you've described..

Columns to Rows - Part 2

There's a sample sheet there where you can test it out.

Thanks .That was wonderful.It might have taken me a day or two to complete that job manually.
That code worked like magic.Thanks again