address in excel

[lrdeepak]

i have the following data in excel in separate colomns. i want to bring the following data of a customer in one row. please help


Customer Master Billing Address Location Address
Name
CST No CST Date City State Pincode LST.No LST Date ECC No
Address

SIKA INDIA PVT. LTD. - GOA
GOA M(CST)5566 29-12-2006 GOA GOA 403722 TIN:30241103190 AAECS1119FXM001
L-41, VERNA INDUSTRIAL ESTATE,
SALCETE,
SIKA INDIA PVT. LTD. -MUMBAI
C-320, TTC INDL. AREA, 27910558507 01-09-2006 NAVI MUMBAI MAHARASHTRA V-837/A-690 01-09-2006 APPLIED
MIDC PAWANE VILLAGE,
PAWANE
SIKA INDIA PVT. LTD. -MUMBAI
NAVI MUMBAI 27910558507 01-09-2006 NAVI MUMBAI MAHARASHTRA V-837/A-690 01-09-2006 APPLIED

C-320, TTC INDL. AREA,
MIDC PAWANE VILLAGE,
PAWANE

SILTAP CHEMICALS LTD. (HALOL)

PLOT NO.1307 HALOL GUJARAT
G.I.D.C
DIST PANCHMAHAL
SILTAP CHEMICALS LTD.(MUMBAI)
612, RAHEJA CHAMBERS, MUMBAI 400021
NARIMAN POINT,
SILVASA PLAST
SURVEY NO.98/1, 26000002544 11-11-1997 SILVASSA GUJARAT 396230
SILLI VILLAGE
SILVASSA INDUSTRIES PVT. LTD.
342, KHARADPADA, DNH/CST/1381 24-10-1994 SILVASSA U.T.DADRA & 396235 DNH/ST/1442 24-10-1994 AAACR3892AXM001
NAGAR HAVELI
NAROLI,

 

[stanleydgromjr]

lrdeepak,

Please post a screenshot of your sheet(s), what you have and what you expect to achieve, with Colo's HTML Maker.

http://www.puremis.net/excel/downloads.shtml

Or, with Excel Jeanie HTML 4.

http://www.excel-jeanie-html.de/index.php?f=1

Have a great day,
Stan