Power BI Data Modelling

HI selimovd ,

Solution looks promising and its works with data provided.

However data which i have provided is dummy one and in actual data it is not necessary that we always have two rows between every heads, for e..g data could be any thing like as below

ColA        ColB         ColC
Data         Data         Data
L-1             2              3
L-2             5              6
L-3            22            3322
L-4            231          233
Cloud       Cloud      Cloud
L-3             8               9
L-4            11             12
L-6            78             121
Azure       Azure        Azure
L-5            14             15
L-6            17              18

- It is not necessary that we have only three heads such as Data, Cloud, Azure etc, it could be any number.

- Number of columns are not fixed are also not fixed, it could be ColA, ColB, ColC, ColD etc, again it could be any number.

- Number of rows between two heads can be any, it not neccessarily two, in above data set, there are 4 rows for Data, 3 rows for Cloud etc.

Please suggest!!

Thanks

Amit