I get an excel sheet sent to me each day. I have to manipulate it down to a basic one line table:
The excel sheet that comes to me the next day, I need to manipulate it down to units and hours spent and add the date column. I don't want to replace the data in the sheet that I did this to yesterday, instead I want to have it build a table that looks Like this:
How do I get the excel sheets that come in daily to combine in BI to a new table? Any help would be great.