So apologies in advance is this has been answered elsewhere!
So I am complete noob to this kind of thing but I want to create copilots for my clients based on data I am collecting in my research for them.
The data is a mix of 'structured' data, e.g. numbers, company names, dates, and unstructured data is the form of free text. I have tried doing this with just excel and it works to an extent in that I can ask about a technology and it does a nice job of summarising it within limits plus it provides citations from the file. However if I ask it to summarise the technology from company x it falls over. In other words it doesn't seem to cross reference the rows or cells.
The data in excel is obviously 1 row per entry.
In my (probably naïve head) it should be straightforward but clearly it isn't, unless of course I'm doing something obviously wrong. Except it's not obvious to me.
Thanks in advance and all help is gratefully received!
