This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Hello. No, all the data its possible in the same sheet (or in distinct sheets), like this.
And the workflow like this:
If you have the data in differents files, only use Union Tool to unify the datas. If you have the data in differents sheets, apply Unión tool too. If you have the data in the same file/sheet, with my workflow your obtain the answer like the result.
If you need the groups in differents outputs (sheets, files, tables, etc), use filter tool to separate the groups, like this.