Begginer question : Separate tables from one column

[Anonymous]

Hello everyone, I have a small question.

I got data like this:

Table1

Data...

Table 2

Data..

... Until 6 tables.

Everything is in the same column and my goal would be to make 6 differents queries with their own table. I tried the basic solution to delete rows and keep the table that I want, but obviously it's not very automatic, if I want to add new files in the future it'll not work.

I was thinking of Table.Split but i'm not so sure on how to use it there. Do you have an idea on how I could do to separate the tables? Please

Thank you!!

Here are my data if you want to understand better.

https://we.tl/t-8mb40HGcur

[KNP · Accepted solution]

Hi @Anonymous, 

See attached PBIX file for an example of one way to do it.

May require some tweaking depending on your actual data.

Let me know if you have any questions.

[Anonymous]

Hello, thank you for your answer!

I could do it and I'm not gonna lie, it's a very smart way to do it, I like it a lot! I'll try to work more on my data and comeback if I see that I have a problem with this.

Thank you a lot!!!