5, Vaniga Valaagam,, Old Bus Stand,, Salem, Tamilnadu, India - 636001Ĭan someone suggest a way to achieve both. User_id pagetitle companyname Category1 Category2 Categor圓ĥ09 Digital Arts Digital Arts Advertising, Media & Promotions Audio Visual Equipment Audio Visual Equipment- Rentalsĥ09 Digital Arts Digital Arts Advertising, Media & Promotions Outdoor Media Advertising- Signs, Neon, Glow Etcĥ09 Digital Arts Digital Arts Advertising, Media & Promotions Printing & Printers Digital Printingĥ09 Digital Arts Digital Arts Advertising, Media & Promotions Printing & Printers Flexographic Printingĥ09 Digital Arts Digital Arts Advertising, Media & Promotions Audio Visual Equipment, Outdoor Media, Printing & Printers, Printing & Printers Audio Visual Equipment- Rentals, Advertising- Signs, Neon, Glow Etc, Digital Printing, Flexographic PrintingĪnd also merge content from multiple columns to 1 eliminating the empty columns.Īddress buildingname landmark Locality sublocality City State Country pincodeĥ Vaniga Valaagam Old Bus Stand Salem Tamilnadu India 636001Īs if i use concat() with separators the above also includes empty and include multiple separators. ![]() Release the Ctrl button, type the closing parenthesis in the formula bar and press Enter. Press and hold Ctrl and click on each cell you want to concatenate. ![]() Type CONCATENATE ( in that cell or in the formula bar. Take distinct of each column and concatenate if multiple distinct exists for a record Here are the detailed steps: Select a cell where you want to enter the formula.I am using mysql and want to do the following:
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |