Howdy!
I have several dozen sheets, in a handful of files, each with 3 columns of the same data - reference, name, URL - no formatting, all text - but because there are millions of rows, they're split up.
I want to find a way to sort all of it into a new file (and due to the length of the data, new sheets) in alphabetical order.
At this time, that's all I need to do. I've been looking at PowerQuery/Pivot, but can't seem to find a way to do this; I think they're more useful for combining similar, related data sets, rather than multiple-of-the-same-datasets.
i.e. I want to take 25 million similar rows, scattered over multiple sheets/files, and sort all into a new document, where sheet 1 = "Aaa...-Bac...", sheet 2 = "Bad...-Cro...", etc.
It doesn't matter where the new sheet breaks are - they can be less than the full 1048576 rows, or every sheet can be the full 1048576 rows.
I have to do manual work on the result, but do not need to create more rows.
The top-most few thousand, and the bottom-most few dozen-thousand, records (i.e. the first, and the last, records) will need some editing, but the purpose of this sorting, is to get them to the top, and bottom, of the 25-million row list so I can do that, without working on the first/last records on one sheet, then the next, then the next...
I can work with VBA if I need to, but I'm wondering if there is a way to do this more automatically before I start diving in.
I've looked at KuTools and AbleBits add-ons and don't see anything there, either.
Any help or pointers appreciated!
Bookmarks