Hi there,
I'm trying to union together a bunch of data collected in different spreadsheets over the years. I was easily able to union two of the tables, but for some reason when I try to drag the third sheet, it won't let me. Any thoughts on why this might happen?
Hi Kristie,
I think you can use union only if data coming from same spread sheet. I think in your case you can drag spread sheet only associated to ReponsesSU15 excel file, cannot drag spread sheets of OutcomeSurveyReport12 or any other excel file. I'm not sure about this.
Thanks
Hi there -- You can union sheets from different files. The current union is from two different files, just trying to add a third file.
Hello Kristie,
You need to work with wildcard as below snapshot. Just keep them on same location. This will be issue for you.
Ak