Multiple Headers in Power Query

[chakravarthypsk]

Hi,

Greetings to All !

I am really struggling with multiple headers in power query. I have huge loads of files which have multiple headers wherein I have the dates as one of the headers.
I am trying to prepare a sample dashboard for my team, tried to convert the dates in the header into a column with advanced unpivot option, however, could not succeed.
I need the dates alongwith other columns, so that i can calculate the volume processed on daily,weekly and monthly basis.
I have given the dates only for two days as an example, but I have huge excel files like this.

This can't be combined with what you've already added to your post.

I am really struggling to get this fixed for the past 2 days, hence, any help on this is really appreciated.

Thanks a lot and cheers!!

02222021.xlsx
	B		D	E	F	G	H	I	J	K			N	O	P	Q	R	S
1	SSSS		16-Sep-19										17-Sep-19
2			Performance										Performance
3	SL. No.		Volume Processed	B Hours	T Hours	it	Achieved Time	Efficiency%	Utilization %	Actual TC Hours			Volume Processed	B Hours	T Hours	it	Achieved Time	Efficiency%
4	1		489	##	7.92	825.11	883.02	93%	204%				858	19.05	11.29	1446.14	887.17	163%
5	2		195	##	7.61	312.52	330.52	95%	95%				253	12.63	7.85	747.00	703.85	106%
6	3		1850	##	7.85	981.18	1248.28	79%	265%				1880	13.20	7.79	896.73	792.26	113%
7	4		0	##	0.00	0.00	0.00	0%	-				227	15.82	7.68	567.94	949.15	60%
8	5		546	##	7.86	389.71	1265.00	31%	268%				759	14.79	10.02	587.17	887.36	66%
9	6		386	##	7.96	509.09	411.03	124%	95%				390	5.50	7.88	365.19	330.22	111%
Sheet1

Cell Formulas
Range	Formula
N1	N1	=D1+1
S4:S9,I4:I9	I4	=IFERROR(G4/H4,"0%")
J4:J9	J4	=IFERROR(E4/F4,"-")

 

[RoryA]

This appears to be a duplicate thread, so closed.