need help, really! There is data:

id period goods group of goods revenue

123 201801 apples fruit 65 rub

123 201802 apples fruit 21 rub

124 201801 cherry fruit 10 rub

127 201803 carrots vegetables 9 rub

129 201803 potato vegetables 4 rub

129 201801 potato vegetables 1 rub ...

It is necessary to reduce them to this form:

id Product Group 201801 201802 201803 ...

123 apples fruit 65 rub ...

124 cherry fruit ...

127 carrots vegetables ...

129 potato vegetables ...

  • At Stack Overflow in Russian, questions are usually asked only in Russian. Please translate your question into Russian or use Stack Overflow in English. - Akina
  • It was only necessary to translate the text of the question, but the field names are not necessary. Add more that your attempt to solve this should happen. - 0xdb 2:38 pm

0