What are these duplicates?

Question

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

Answer 1

duplicates are not important in this case because we will create 3 columns (2016, 2017, 2018) and we will import thier values using vlookup

Answer 2

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 )

What are these duplicates?

Submit an answer

related questions