hey, man!
I know that I said I'll come back in 30 minutes, and that was over 13 hours ago, but I've made a few blunders...
1) first of all, the habit of having used Windows for 35 years made me type Excel in the title of this thread instead of LibreCalc as I've permanently moved to Linux from Windows 2 years ago, but I still haven't gotten totally used to Linux's lingo and apps, so yeah... that's where all of these problems started...
It took me
literally hours (ok, maybe not hours but definitely over 1 hour) of total confusion and wondering why I can't find the things you mention in your guide, but all this time I assumed I am in Excel, when - in fact - I've been in LibreCal all along...
And then - after 1 hour of standing there like a moron, pondering what the heck is wrong - it finally hit me: "duuude, this is not EXCEL"
But at that time I couldn't edit the post anymore as the 30 minutes of editing allowance will have already passed, and instead of coming here to whine like the little bitch that I am (because I don't know what else I could have said), I figured I would instead install Excel and try your steps in Excel first and - if they worked - I would then save the file in LibreCalc-recognizable format (.ods) and at that point I would have handled the minor adjustments that I had to make...
But, and here was the next problem....
2) Excel can't be installed into Linux.... ok, it can be installed with Wine, Bottles, etc... but since I don't understand those apps (and also I didn't want to install it that way anyway as my Linux is a bit faulty lately (constant crashes and freezes), so I need to reinstall it anyway, and I can't do this until I return home from the city next week... it's a whole domino of events that I need to do in the right order, but I won't bore you with everything, just know that - at the moment - the only way to make Excel work was to install it in a virtual machine, so....
3) on I went to install virtual machine, then look through my old HDDs for a version of MS Office that I knew I had from memorial times when I still used Windows... I finally found that damn Office file after another hour of connecting and disconnecting HDDs and searching through few Terrabytes of files....
So anyway, long story short, I did find a working Excel file, I did manage to install Windows, and to make these things work, but by that time it was 4 AM in the morning, and I didn't have the mood to keep going with this, so I went to sleep and now that I'm awake, the first thing that I did was powering my virtual machine on, and going to Excel to try your guide and - as always - as the saying here in Romania goes "misfortunes never come alone" obviously that my version of Excel (from 2016, that's all I had to go with) didn't have the icons / buttons that you mention in your guide, as you can see in the screenshot below, so now I'm once again - at the mercy of kind people like you - who hopefully will tell me what to do next, as - apparently - I am too dumb to be able to figure it out myself
View attachment 479277
So yeah, as you can see in this screenshot there is no "Get Data > From File > From Folder" option anywhere, and I did try to click on other options but none of them allows me to select folder, I think the only option that allowed me to OPEN (not select) the folder was the "From Text" icon, but this didn't work as it didn't select all files (I tried the SHIFT + arrow trick, but it didn't work)... and the files are not even text to be honest, they're CSV, so yeah... not sure what to do about it....
So, please - and if you don't mind having to babysit me in this already dragging for too long process, for which I apologize - please tell me what else I can do.
If you don't want to, or can't say as it would take too long to spoonfeed me (understandable, honestly) I'll just go ahead and manually copy-paste 100s of files like a lunatic because that's my skill level when it comes to these things. It won't be pretty or pleasant, but I do need to merge those files one way or another, so.... good luck to me I guess...
