split power query Table as per subheads

[vsgmpudi]

Hi

I have run a Power query and consolidated no. of sheets in to one table my request is to split the consolidated Table into different sheets with the help of power query as per sub heads (Registers, Key Register & Compliant Register. I would be attaching the consolidated table and blank sheets.

I Have not given the full data for security reasons.

Thanks in advance.

 

[ExcelToDAX]

I would keep the same table that you already have, and then don't load it to the front-end. I would then create 2 new tables that reference the first table and choose which columns you want for each table