You are reading a single comment by @aggi and its replies.
Click here to read the full conversation.
-
Cheers. Think I'll probably go macro and incorporate creating the folders into the macro (I currently just paste it into a batch file).
@Chalfie Powerquery probably would do it neatly and just spit it out in a new table in the same spreadsheet. I may try that method if I get some free time as it's bound to cock up in some way.
aggi
Macro I think.
Or, to avoid nested then this is a little easier as it's just cut/paste a range.
But it's still a bit crap and it's pretty much nested anyway.