how to merge cell please help

Please help
i had a excel workbook with few thousand lines of name, address

A

1 Name
2 Adrress1
3 Adrress2
4
5 Name
6 Adrress1
7 Adrress2

I need to merge it into some thing like this

A B

1 Name Name, Address1, Address2
2 Adrress1
3 Adrress2
4
5 Name Name, Address1, Address2
6 Adrress1
7 Adrress2

Please help with a VBA code or Marco
Thanks

Best Regards

in B1
=IF(MOD(ROW(B1),4)=1,A1&","&A1&","&A3,"")

then drag fill down the column.

--
Regards,
Tom Ogilvy




"Chuong Nguyen" wrote:

> Please help
> i had a excel workbook with few thousand lines of name, address
>
> A
>
> 1 Name
> 2 Adrress1
> 3 Adrress2
> 4
> 5 Name
> 6 Adrress1
> 7 Adrress2
>
> I need to merge it into some thing like this
>
> A B
>
> 1 Name Name, Address1, Address2
> 2 Adrress1
> 3 Adrress2
> 4
> 5 Name Name, Address1, Address2
> 6 Adrress1
> 7 Adrress2
>
> Please help with a VBA code or Marco
> Thanks
>
> Best Regards
>
>
>

Tom - do you have a typo in your formula? Don't you want to reference cell A2
in the formula, as follows:

=IF(MOD(ROW(B1),4)=1,A1&","&A2&","&A3,"")

Cheers - Jeff


"Tom Ogilvy" wrote:

> in B1
> =IF(MOD(ROW(B1),4)=1,A1&","&A1&","&A3,"")
>
> then drag fill down the column.
>
> --
> Regards,
> Tom Ogilvy
>
>
>
>
> "Chuong Nguyen" wrote:
>
> > Please help
> > i had a excel workbook with few thousand lines of name, address
> >
> > A
> >
> > 1 Name
> > 2 Adrress1
> > 3 Adrress2
> > 4
> > 5 Name
> > 6 Adrress1
> > 7 Adrress2
> >
> > I need to merge it into some thing like this
> >
> > A B
> >
> > 1 Name Name, Address1, Address2
> > 2 Adrress1
> > 3 Adrress2
> > 4
> > 5 Name Name, Address1, Address2
> > 6 Adrress1
> > 7 Adrress2
> >
> > Please help with a VBA code or Marco
> > Thanks
> >
> > Best Regards
> >
> >
> >

"Chuong Nguyen" <chuonghnguyen@sbcglobal.net> wrote in message
news:uiGVxrVxGHA.4416@TK2MSFTNGP03.phx.gbl...
> Please help
> i had a excel workbook with few thousand lines of name, address
>
> A
>
> 1 Name
> 2 Adrress1
> 3 Adrress2
> 4
> 5 Name
> 6 Adrress1
> 7 Adrress2
>
> I need to merge it into some thing like this
>
> A B
>
> 1 Name Name, Address1, Address2
> 2 Adrress1
> 3 Adrress2
> 4
> 5 Name Name, Address1, Address2
> 6 Adrress1
> 7 Adrress2
>
> Please help with a VBA code or Marco
> Thanks


Put this into B1 and copy it downward as needed:
=IF(A4="",A1&", "&A2&", "&A3,"")

Cheers,
Joerg