Data Modelling Question: Making Excel File Power BI Ready

[TotunG]

Hi there,

I've been given a task of creating a Power BI from a rather unorganised Excel unfortunately. Therefore it looks like it needs some work using Power Query. The main issues I have are the following:

- Excel sheet contains hidden columns 

- Column names change as week progresses (e.g. WK46 - 14/11/2022 will be deleted once passed meaning Power Query references will not know what to do if I 'clean' the data e.g. delete Column as this no longer exists as the data shifts/user deleted)

- Lots of data on one sheet

Any ideas would be much appreciated. 

ID	Name	Stock	Dlivery	Dlivery	Dlivery	Column	Demand	Demand	Demand
			WK46	WK47	WK48		WK46	WK47	WK48
2214	Apple	321	53	54	24		432		432
4213	Apple	231			2
6345	Carrot	2313		43			342		5
6477	Pear	234	24		32		1	5	5

[vanessafvg]

it all depends on what your are required to do with it.  Please provide examples of your expected results.