Split dataset into two reports

[Anonymous]

I am working on a dataset like below.

First 4 rows are one grouping. Next 3 rows are another grouping.

While creating reporting, I would like to have two scheets each with their own grouping. 

Trn	Type	SNo Ref	Sender	Receiver
ewew	new	22324	Aaron	Tim
bbgg	old	24334	Ben	Carr
hnhn	new	53454	Aaron	Tim
hnhm	new	44455	Meg	Alen
ghjui	old
hnmm	old
eghgh	old

[Thingsclump · Accepted solution]

Hi @Anonymous 

Below is what I suggest.

1) Import whole table into powerquery (will name it as table A).

2) Right click and then refrenece. This new table rename it as table B. In table B, go to Home tab and then keep rows. Select keep top rows and enter 4.

3) same as step 2 but use remove top rows and enter 4.

4) right click on table A and then uncheck enable load in queries pane.

Thanks

thingsclump

www.thingsclump.com 

Mark it as accepted solution if it solves ur problem.

[StefanoGrimaldi]

isnt clear what you looking for, give a example or a more detailed explanation 

[Anonymous]

Hi @StefanoGrimaldi 

The excel table is structured as shown in the above table. This excel sheet is in a folder which is updated with one new excel file same as the above table every week. 

I am looking to create a report out of first 4 rows seperately and the last 3 rows seperately. Once set, I will keep on refreshing the report for latest week's data.