How to transform multiple tables in one excel sheet to one table with Power BI

Question

I would like to transfer this humanly readable table either into one long table, for example through an "Attribute" Column which then includes "Category A" and "Category B" or I would like to split them into multiple sheets within PowerBI. The "delimiter" is always a empty column.

Answer 1

If my prediction is correct-

You have a single spread sheet with data from several categories.
You wish to import all of your data into Power BI.
However, each category will require its own sheet.
You can get your desired data sets in Power BI by following the steps below:

Set the sheet to power bidding mode.
Duplicate your data set as many times as you wish, depending on the number of data sets you have.
Remove all columns from all data sets except the ones you need in the current data collection.
This should give you the data sets you want in power bi.