[Free] Basic Google Sheet Extension with Web Component

first add sheet id and google sheet is in viewer mode

Hi ,
plz how to select UNIQUE in col A.
THX

how to give a segmentation sign like a | in every columns in show , ex :
1 | Michael | Minesotta
2 | Klose | Newyork

an how to delete ( and ) in show , ex :
(1 Michael Minesotta) become 1 Michael Minesotta

thanks

I am using the Query tool.Now what to do if I want to pass a variable defined in the app inventor as the condtion
For eg, inQ2 condition is B=Label2.Text
how to implement this

B=‘Label2.Text’ text in single inverted comma.