in Technology by (1.9m points)

How to combine two Excel files with the same fields but different data (different years)?

1 Answer

0 votes
by (1.9m points)

Suppose, we have five different Excel files (2007.xls, 2008.xls, … 2011.xls) with the same fields (film name, genre, budget, rating, profitability, etc.) but with data of different years (2007 to 2011). Can someone tell me how can I combine the film name, genre, and profitability so that I can see the visualization of 2007 to 2011 in a single chart?