Managing Excel Data is some times bit complicated !
Let me explain a scenario which is a real time scenario from a Student ;
The Data contains -
Sales Table (Only Columns available - Date and Sales Value) ,
"No" Product information is in Sales Table.
Product Table contains Data as mention below in Each Row, like
1 Jan 2020 - 31 Jan 2020 - Apple
1 Feb 2020 -28 Feb 2020 - Orange;
and so on
Now I need to add a Column - "Product Name" to the Sales Table based on the Range of Dates available in Product Table.
Is this Tricky?? Watch this video to understand how to solve this in Power Query Editor