XCEL data separation

Copper Contributor

I have a large column of numbers that I need to separate with a blank row each time the number in that column changes.  any suggestions how to do this

 

3 Replies

Hello @Traffic20,

 

Please refer to the following:

https://www.youtube.com/watch?v=vwLP8CwoKLg

 

As a note... if there are multiple number changes in consecutive rows, then you may need to manually adjust blank rows.

Please send a folder with the problem to better understand your problem and to find the best possible solution for you ...
A lot of skills can help here ... better than me ... but nobody can clairvoyance.

Thank you for your understanding in advance

Nikolino
I know I don't know anything (Socrates)
folder = a excel sheet