how to create a dimension with non formatted excel sheet

[bkan]

Hi All,

I have an excel sheet which have multiple tables (same tab). I want to create a dimenssion, new dimension.  that lookslike 

I want new table like below

Thanks

[Anonymous]

Hi @bkan ,

Based on the description, @NaveenGandhi provide solution should be helpful.

If you have solved the problem, please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Wisdom Wu

[NaveenGandhi · Accepted solution]

Hi @bkan 

I have created a Power Query solution for this. Let me know if this helps.

If this post helps, then please consider Accept it as the solution to help the others find it more quickly. Appreciate you kudos!!

Follow me on LinkedIn!!!

[bkan]

@NaveenGandhi Thanks I will test and update you.