quickstep25/excel-delete-grouped-rows

Last active June 25, 2021 05:18

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/quickstep25/71f2703316eb5521af1a93e5387ca424.js"></script>
Save quickstep25/71f2703316eb5521af1a93e5387ca424 to your computer and use it in GitHub Desktop.

Download ZIP

When exporting data from another source, such as SSRS, the groups will be maintained when opened up in Excel. This poses a problem when you have total and subtotal lines that were not created by Excel natively. So when you ungroup the rows in Excel,

Raw

excel-delete-grouped-rows

_

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment