How to add data to blank rows if the data I want is below my blanks?

[jpolomsky]

Hi, this is my issue

Blank

Blank

Blank

DATA 1

Blank

Blank

Blank

DATA 2

Blank

Blank

Blank

Data 3

I want blanks, to reflect the value below, so first 3 blanks to have DATA 1 value, next 3 blanks DATA 2 value, and so on.

It is basically the opposite of

DATA1

Blank

Blank

Blank

Any ideas? Thank you

[atcodedog05]

Hi @jpolomsky 

Is this what you are looking for. If not please provide expected output.

Workflow:

Hope this helps : )

[jpolomsky]

Hi, i am not sure it would work, because you used ascend/descend, however my data looks more like data in excel. 

[atcodedog05 · Accepted solution]

Hi @jpolomsky 

Here is how you can do it.

Workflow:

Hope this helps : )

[jpolomsky]

Worked like a charm 😉 Thank you!

[atcodedog05]

Happy to help : ) @jpolomsky 

Cheers and have a nice day!