I am trying to combine cells and show in one cell as each cell contains product skus comma seperated. Need to combine these cells with comma seperator in seperate cell in same column. For this i am using
=TEXTJOIN(",",TRUE, G5,G10,G19,G27,G39,G46,G59)
But getting error:
Text result of TEXTJOIN is longer than the limit of 50000 characters.
use query (that's the only way):
=QUERY({G5;G10;G19;G27;G39;G46;G59}&",";;9^9)
or:
=QUERY({QUERY({G5;G10;G19;G27;G39;G46}&",";;9^9); G59};;9^9)
A Sheets cell cannot have more than 50,000 characters:
When you convert a document from Excel to Google Sheets, any cell with more than 50,000 characters will be removed in Sheets.
I'd suggest you to split your data into several cells.