I need a much complicated function.
Every day I collect data referring to brands. For example:
Jimmy Jone’s 35
The number associated to each brand change every day. The name of brands no, but new brands could be added every day. So every day I get two columns, and I need to add data to my datasheet. What I want to obtain is that:
1st 2nd 3rd
Jimmy Jone’s 35 52 32
Facebook 28 58 74
H&M 36 10 52
that means observing data brands during a period of time. The number of brands are hundreds, and time is days of years. Could I use Libre Calc to do all this? If so, how could I set my datasheet?
Thanks a lot in advance!!