Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Begginer question : Separate tables from one column

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

2 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable

      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!!!