0

I need a conversion of the individual cells for a wordpress plugin. I have a huge amount of data that I need to transform ! I had already tried it with TRANSFORM=(A1:A4) , but I do not get the result. And of course there must be a gap after the last text section. In this case ( src ). I hope someone can help me.

ps: I found a Tutorial on YT , i gonna try it :)

Google Sheets transform with space/gap

Dawid Fleszewski
  • 3
  • 2

1 Answers1

0

Try:

=ARRAYFORMULA(SPLIT(FLATTEN(A1:D1 & "♥" & FILTER(A2:D, A2:A <> "")), "♥",,))

kishkin
  • 5,152
  • 1
  • 26
  • 40
  • =ARRAYFORMULA(SPLIT(FLATTEN(A1:D1 <- you mean mybe A1:C1, i got only 3 rows. It doesnt work :/ Message -> Error – Dawid Fleszewski Feb 16 '22 at 13:20
  • I added `D` for the gap. – kishkin Feb 16 '22 at 13:22
  • what do you mean with the hearts ? :D i am reading more about FLATTEN. Thanks for putting me on the right track :) but am a little annoyed, does not work – Dawid Fleszewski Feb 16 '22 at 13:43
  • @DawidFleszewski `♥` is just a separator which is rare in common texts. Works on my test sheet: [pic](https://i.imgur.com/qLQY1zX.png) – kishkin Feb 16 '22 at 14:40
  • You are Pro. Im very happy, thank you very much. it did not work at first. Very helpful for others who are looking for exactly the same thing. Change your language in Sheets ! I changed to english and it works. Thank you ;) – Dawid Fleszewski Feb 16 '22 at 17:30