Forum Discussion
Within exported file, how to move subtotals over a few columns to align properly?
When we export certain reports from our ERP system it always improperly aligns the subtotals. How can I easily move every single subtitle over, say, 10 columns?
The yellow highlighted need to be moved so they START in column K so these subtotals properly align with their columns. Go To Special or what else can I use to easily/quickly do this cut/paste step? There are a ton of rows of data, and you can't sort as these subtotals won't follow each customer name they're subtotaling.
8 Replies
Add a filter.
Custom number filter on A (Something like >100 to exclude the Periods).
You'll get this:
Cut/Paste to K, then remove the Filter.
That didn't work, but, dahhh, I should have thought of that. What am I doing wrong!? The values would only be 1-12 (for the periods/months), so I would think anything > 12 to use as filter, yet it doesn't work. Any ideas?
I am re-attaching the file with more data so you can see it doesn't work.
The filter is not considering all rows of data because of the intermittent blanks. First, clear the filter. Next, select the entire columns encompassing the data, then apply the filter. The custom filter should now see all your data.
