I want to assign some text to elements of a dataset. I have a worksheet called test1 The first column is called data1 The column type of data1 has been set to text I try the following: test1_data1[1]="aaa" type $(test1_data1[1]) the type command returns "1" The element in the worksheet changes to "-" from whatever it was. I can manually enter text in worksheet positions. The type command always shows "1" however. If I use numerical values then everything works.
My goal here is that I am using a script to extract data from a collection of worksheets and then at one line to my test1 worksheet for each of the processed worksheets. I want to label each row of the worksheet with the name of the worksheet that the data came from. I am able to get the numerical data into this worksheet, but not the text labels.