Hi,
I am copying google sheet data (not exporting) into clipboard. Then, using split lines (utility - Strings), taking it in collection. But, issue is: I have 17 columns in excel and in collections i am getting those 17 columns in one field. How can i divide them in different columns as were in excel.?
Also, there is a space between column names like:
Col A: Timestamp
Col B: Is there a request type?
Col c: What is the request? etc. etc.
Please advise.
I am copying google sheet data (not exporting) into clipboard. Then, using split lines (utility - Strings), taking it in collection. But, issue is: I have 17 columns in excel and in collections i am getting those 17 columns in one field. How can i divide them in different columns as were in excel.?
Also, there is a space between column names like:
Col A: Timestamp
Col B: Is there a request type?
Col c: What is the request? etc. etc.
Please advise.