What are these duplicates?
Are these duplicates mistakes in the data collection process, and, if not, aren't we deleting critical information that would misrepresent our P&L statement? Thanks
2 answers ( 0 marked as helpful)
duplicates are not important in this case because we will create 3 columns (2016, 2017, 2018) and we will import thier values using vlookup
so instead of using code 101010 (for example) like this
code amount
101010 2016 value
101010 2017 value
101010 2018 value
we will use it as
code 2016 2017 2018
101010 ( value ) ( value ) ( value )