Forum Discussion

anshpalash's avatar
anshpalash
Helper II
4 years ago
Solved

Split Table

Hi, I want to split this table into two. The table below the row which says "Parameters" should be the second table. The number of IDs in every file is different. So, the row number containing...
Need Help
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    4 years ago

    Hi, anshpalash ;

    You can use the Ashish_Mathur's method, and there is another method you can also try:

    1.Transpose table in power query .

     

    2.remove after "Parameters" columns

    3.Transpose table

    The same method apply second table.

    Best Regards,

    Community Support Team_ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-yalanwu-msft's avatar
v-yalanwu-msft
Community Support
4 years ago

Hi, anshpalash ;

You can use the Ashish_Mathur's method, and there is another method you can also try:

1.Transpose table in power query .

 

2.remove after "Parameters" columns

3.Transpose table

The same method apply second table.

Best Regards,

Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.