Split Table

[anshpalash]

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 "Parameters" would be different for every file. 

Is there any way I can split the above table starting at the row that says "Parameters"? Would really appreciate any help. Thank you!

[Ashish_Mathur · Accepted solution]

Hi,

File attached (see below signature).

[v-yalanwu-msft · Accepted solution]

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.

[Ashish_Mathur]

Hi,

Where will the Date and the first 5 rows go?  Please show the expected result very clearly.  Also, share data in a form that can be pasted in an MS Excel file.

[anshpalash]

all rows above "Parameters" would be a separate table. All rows below "Parameters" will be a separate table. 

[Ashish_Mathur]

Will the rows above the Parameter row always be 8?  Also, as requested earlier, share data in a form that can be pasted in an MS Excel file.

[anshpalash]

No, the number of rows above parameter will not always be 8. That number changes for every file. Here is the data:

Date
27-Aug
ID	Sale
1	10
2	15
3	25
4	23
Parameters
1	Location	Austin
1	Type	Vehicle
2	Location	Indy
2	Type	Boat
3	Location	San Jose
3	Type	Vehicle
4	Location	NY
4	Type	Bike

Thank you!

[Ashish_Mathur]

Hi,

You may download my PBI file from here.

Hope this helps.

[anshpalash]

The link is not working for me. Thank you

[Ashish_Mathur · Accepted solution]

Hi,

File attached (see below signature).