Forum Discussion
Tom_Davenport
Apr 25, 2024Copper Contributor
inserting break rows in a data set
Hi,
I have attached a data set. in columns. i want to insert a row when the number in column C changes. the input data in Columns A, B, C, D and E. I have attached screen shots, hopefully makes sense!
thanks
Tom
- Patrick2788Silver ContributorYou could use the Subtotals feature through Data | Subtotals. It's likely going to give you some summary data you don't need that would have to be cleared.
- Riny_van_EekelenPlatinum Contributor
Can only wonder why. It's the worst thing you can do as it destroys the data set. What are your intentions?
- Tom_DavenportCopper Contributorthanks for Getting Back Riny, its so i can upload to an ERP system we are using. i need to do it this way so the API works. it will just be used for this purpose so won't ruin the master data.
- Riny_van_EekelenPlatinum Contributor
Tom_Davenport Fair enough. Can you upload a file or a link to it on OneDrive, for example. Difficult to help based on a screenshot alone.