XCEL data separation

%3CLINGO-SUB%20id%3D%22lingo-sub-1556759%22%20slang%3D%22en-US%22%3EXCEL%20data%20separation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1556759%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20large%20column%20of%20numbers%20that%20I%20need%20to%20separate%20with%20a%20blank%20row%20each%20time%20the%20number%20in%20that%20column%20changes.%26nbsp%3B%20any%20suggestions%20how%20to%20do%20this%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1556759%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1556815%22%20slang%3D%22en-US%22%3ERe%3A%20XCEL%20data%20separation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1556815%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F745101%22%20target%3D%22_blank%22%3E%40Traffic20%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20refer%20to%20the%20following%3A%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DvwLP8CwoKLg%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DvwLP8CwoKLg%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAs%20a%20note...%20if%20there%20are%20multiple%20number%20changes%20in%20consecutive%20rows%2C%20then%20you%20may%20need%20to%20manually%20adjust%20blank%20rows.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1556818%22%20slang%3D%22de-DE%22%3ESubject%3A%20XCEL%20data%20separation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1556818%22%20slang%3D%22de-DE%22%3EPlease%20send%20a%20folder%20with%20the%20problem%20to%20better%20understand%20your%20problem%20and%20to%20find%20the%20best%20possible%20solution%20for%20you%20...%20%3CBR%20%2F%3E%20A%20lot%20of%20skills%20can%20help%20here%20...%20better%20than%20me%20...%20but%20nobody%20can%20clairvoyance.%20%3CBR%20%2F%3E%3CBR%20%2F%3E%20Thank%20you%20for%20your%20understanding%20in%20advance%20%3CBR%20%2F%3E%3CBR%20%2F%3E%20Nikolino%20%3CBR%20%2F%3E%20I%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1556822%22%20slang%3D%22de-DE%22%3ESubject%3A%20XCEL%20data%20separation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1556822%22%20slang%3D%22de-DE%22%3Efolder%20%3D%20an%20excel%20sheet%3C%2FLINGO-BODY%3E
Occasional Visitor

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.

In a previous post I talked about how to insert a line at each change in a column of a table or data range in Excel. In this tutorial we'll look at how to i...
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