How to save List in google sheet in one cell? and get back data in list


when customer orders me 3 or 4 products, so how to store the data in single row ?

You can Check the Picture.

Data is saved but i cant retrieve the data in list .

After getting the data use split text at either empty space or what did you used to merge two products into single just use it and it will gives you the list…

Eg if the data is (1 2 3) then use split at empty space so it will gives you three items as a list

simple fact

Suppose if it is β€œ3”,β€œ2”,β€œ5”

Then split at , or use list from CSV row text and then for each item replace the text of " with empty-string

1 Like