Hi there, with the good use of the Plugin now it is possible to get the 90% of what I can do through googlescript/sheet, in this case Im getting the value from a column, make those Unique and Join them. But what Im in need is to take the result of the JOIN (the splitted array) and distribute in a …

Nice, but you have a couple of extra columns that you don’t need. Once you have your Unique items, then you only need two more columns: the equivalent of your begin column, except start the numbering at zero a single value column, that takes “begin” from start, from the unique column. Here is a c…

Take a look at this: [Glide: Transpose Data Columns into an Inline List with the MIRACLE METHOD] I had to do something very similar just a few days ago. In my case, I wanted to transpose an array column. The general approach that I came up with (which worked for me) was: Create anoth…

you know, more or less I had the same idea (but using a numbered column), I didn’t go through this because I was thinking was a bit too elaborated… and actually it is, I would prefer to have a kind o command that make it easier. But ya, Ill try your way for now. Thanks a lot.

Yes, I agree that it’s more complicated than it should be. And I’m certainly open to ideas for making it simpler.

Not even the time to think much more and the solution came easily! Wow, yesterday night I lost 4 to 5 hours to think how to do that… Here the pretty miracle! If some one can improve it, please let me know!

That’s simply great! We ( @Robert_Petitto ) should make a tutorial of this. Thanks! What I would like to have now is a auto-numbering column, so that we can have a real dynamic feature, because if you exceed the provided number then it stop to work. Or do you already have a solution?

[image] MIKAHEL: What I would like to have now is a auto-numbering column, so that we can have a real dynamic feature, because if you exceed the provided number then it stop to work. Or do you already have a solution? Yes, that would be useful. And no, I don’t have a solution. For my specif…

I don’t know if somehow via the CODE column, maybe with javascript… maybe not Hyperformula ROW() doesn’t works, it doesn’t understand the ROW presence. Feature request?

[image] RowID is great. Could REALLY use Row Number Feature Requests Yes, this can be added in Google Sheets…would rather have a native solution. Just a simple 1 through X where X is the number of rows in the table. This would work REALLY well with the Single Value colum…

How to Flatten a vertical Array (plugin use)

Ask for Help

Darren_Murphy November 6, 2021, 3:17pm 10

I wouldn’t be surprised if we have it fairly soon.

Topic		Replies	Views
How to create an array from column values? Ask for Help	4	915	November 9, 2021
Array column using data editor columns Ask for Help	7	763	September 4, 2020
Joined list to Column for colection Ask for Help	5	60	December 19, 2024
Array To Inline Ask for Help	13	2089	January 19, 2022
Split text column Like inline list? Ask for Help	4	1047	March 5, 2022

How to Flatten a vertical Array (plugin use)

Related topics