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

Open 1 Answers 65 Views Technology

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

1 Answer

0

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?

by (301k points)
...