unpivot table with nested headers (date field)

[Anonymous]

I have the following excel.

.

I need the output as following

SlNo	Company	Date	Field	Value
1	Suzon	29-11-2018	Max unit usage	2290.68
2	Suzon	29-11-2018	Max unit usage %	22.90679504
3	Suzon	29-11-2018	Max size usage	493.43
4	Suzon	29-11-2018	Max size usage %	4.93
5	Suzon	30-11-2018	Max unit usage	2603.84
6	Suzon	30-11-2018	Max unit usage %	26.04
7	Suzon	30-11-2018	Max size usage	491.42
8	Suzon	30-11-2018	Max size usage %	4.91
9	Suzon	01-12-2018	Max unit usage	2158.55
10	Suzon	01-12-2018	Max unit usage %	21.59
11	Suzon	01-12-2018	Max size usage	503.36
12	Suzon	01-12-2018	Max size usage %	5.03
13	Ticson	29-11-2018	Max unit usage	3624.43
14	Ticson	29-11-2018	Max unit usage %	36.24426464
15	Ticson	29-11-2018	Max size usage	3662.27
16	Ticson	29-11-2018	Max size usage %	36.62
17	Ticson	30-11-2018	Max unit usage	3612.19
18	Ticson	30-11-2018	Max unit usage %	36.12
19	Ticson	30-11-2018	Max size usage	3680.37
20	Ticson	30-11-2018	Max size usage %	36.80
21	Ticson	01-12-2018	Max unit usage	3341.74
22	Ticson	01-12-2018	Max unit usage %	33.42
23	Ticson	01-12-2018	Max size usage	3408.31
24	Ticson	01-12-2018	Max size usage %	34.08
25	Dicche	29-11-2018	Max unit usage	97.87
26	Dicche	29-11-2018	Max unit usage %	0.978684511
27	Dicche	29-11-2018	Max size usage	1417.31
28	Dicche	29-11-2018	Max size usage %	14.17
29	Dicche	30-11-2018	Max unit usage	96.72
30	Dicche	30-11-2018	Max unit usage %	0.97
31	Dicche	30-11-2018	Max size usage	1342.56
32	Dicche	30-11-2018	Max size usage %	13.43
33	Dicche	01-12-2018	Max unit usage	93.01
34	Dicche	01-12-2018	Max unit usage %	0.93
35	Dicche	01-12-2018	Max size usage	1315.61
36	Dicche	01-12-2018	Max size usage %	13.16

Could you please help me on this to achieve it in Power BI Desktop.

Thanks in advance.

[Ashish_Mathur]

Hi,

My solution here should help - Rearrange a multi heading dataset into a single heading one which is Pivot ready.

[v-lili6-msft]

hi, @Anonymous

Do you mean that you want to transform data like your screenshot into the output you need?

If so, how do you import the data into power bi, I think your expected output should be the basic data structure.

And the screenshot should be a visual.

If the data in excel has the data model, you could use Import Excel workbooks into Power BI Desktop

Best Regards,

Lin