Hi,
I need to concatenate the first column of every 3 consecutive rows
and put the concatenated text in a separate cell.I want to do it till
the end of data the excel file.
For example,I have this data in 3 different rows in a two column table
:-
Column1 | Column2
1
2
3
4
5
6

After concatenating,I want the data to appear as follows :-
Column1 | Column2
1 | 123
2 | 456
3 | ...
4 | ...
5 |
6 |

Can anyone out there please help me out with this ?

Thanks
Tushar


--
tushar_johri
------------------------------------------------------------------------
tushar_johri's Profile: http://www.excelforum.com/member.php...o&userid=30181
View this thread: http://www.excelforum.com/showthread...hreadid=499356