Forum Discussion
Solved
Need help on CONCAT function for multiple column values
COL1 COL2 COL3 CONCAT RESULT B972 02 DPP ('B972','02','DPP');
- Do you want the result to be this: ('B972','02','DPP');
If yes, this the formula
=CONCAT("('",A1,"','",B1,"','",C1,"');")
If I use Arraytotext getting like below
{"B972",2,"DPP"}
{"B972",2,"DPP"}
- How it works if I include COL3
COL1 COL2 COL3 COL4 Result
B972 02 DPP INSERT INTO TABLE VALUES INSERT INTO TABLE VALUES('B972','02','DDP')
B9FD 02 DPP INSERT INTO TABLE VALUES INSERT INTO TABLE VALUES('B9FD','02','DDP')
B976 AB DPP INSERT INTO TABLE VALUES INSERT INTO TABLE VALUES('B976','AB','DDP')- I need to include this INSERT INTO TABLE VALUES in Result 1 columns
Result1 should be
INSERT INTO TABLE VALUES('B972','02','DDP')
- It works, Thank you!