Wow, I've gotten a few episodes over the last couple of months where I was confused and kind of out of it, though I am not sure if it was migraine related. I do get migraines, though I used to only get the auras and ear ringing, nausea, vomiting, loss of vision, etc. I did not get the actual headache. But suddenly last year, I started getting the headaches afterward, though not every time. Then more recently, I had some episodes kind of like what you described.
I had lost my job, but got a grant to go back to school for more training. I was in class one morning, then suddenly felt "off". I wasn't exactly dizzy or spinning, but I felt kind of floaty and weird. So I told my classmate and teacher that I didn't feel right. I thought I might pass out or something. But I went on with the day, and as the day progressed, I was feeling weirder and weirder, though it was hard to explain. So in one class, I was trying to listen to my teacher, whom I was sitting right in front of (we were around a small table). Behind her was a wall of bookshelves. Then I was having trouble focusing, I was trying to look & listen to the teacher, but if I looked even slightly at the bookshelves, I almost felt dizzy, it was strange. It was kind of like my brain had shifted and my focus was out of place, I was getting confused. I heard talking and sort of understood, but not everything. Then she suddenly asked me if was alright and I remember saying No. Then everyone said I was white as a ghost and they thought I was going to pass out. Well, one of the teachers at school happens to be a nurse..so they called her in. They wanted to call an ambulance!! I said NOO...I couldn't pay for it. She took my blood pressure and for some reason it was very high (i'd never had it high like that before). SO they made me sit in the director's chair and put my feet up and stay there. Then they wanted to drive me home, but I'm stubborn, I said no. Over several hours, I felt slightly better and I tried to go on with my day, though I still had trouble focusing or really taking in what teachers and others were saying. I was told I also wasn't making too much sense in what I was saying a few times.
It started subsiding, I went home at the end of the school day, and I also was very tired. I fell asleep early and the next day I still felt a wee bit off, though still a lot better. It was the strangest thing. I never got an aura that I'm used to nor did I get a migraine. So that is why I am not sure if it was migraine related or not.
I do have insurance, but it's a very basic plan and I already met my caps for any kind of testing..so I did not bother to see a doctor. Then a week or 2 later, something similar happened again, though it wasn't as severe. But I sure can relate to what you experienced.