Working with a Table of Tables

[Anonymous]

I am trying to create a dashboard based off a spreadsheet that is shared on our internal sharepoint. The formatting of the sheet is not conducive to creating a Dashboard I have attached a sample of what it looks like below. How Can I get this into a format that is just one large table with the date repeated for each row of the corresponding sub table 

[Icey]

Hi @Anonymous ,

If each table is saved as oen file, try to use combine files option.

Reference:

Combining Excel Files hosted on a SharePoint folder with Power BI

Best Regards,

Icey

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

[Sujit_Thakur]

Dear @Anonymous , 

You can try cut and paste from excel to cut and paste different tables on different excel file

And then use combine folder option from get data 

You will get a combined data 👍

If it help please choose this post as option

And do give kudos from thumbs up button

If you still have doubt please tag me and reply 

Will be happy to help

Regards 

Thakur Sujit