Forum Discussion

Tom_Davenport's avatar
Tom_Davenport
Copper Contributor
Apr 25, 2024

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

  • Patrick2788's avatar
    Patrick2788
    Silver Contributor
    You 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.
    • Tom_Davenport's avatar
      Tom_Davenport
      Copper Contributor
      thanks 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_Eekelen's avatar
        Riny_van_Eekelen
        Platinum 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.

Resources