Last answered:

12 Feb 2023

Posted on:

06 Nov 2022

0

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)
Posted on:

12 Feb 2023

2

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

Posted on:

12 Feb 2023

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 )

Submit an answer