Saya butuh orang yang mengerti soal google sheet script
saya ada data di
sheet 1 di column A1 : "baseball", yang mau saya isi formula akhir nya di column B1: Dengan value akhir sebagai berikut:
[email protected] (baseball mug,baseball gift)|
[email protected](baseball gift for boyfriend, baseball gift for girlfriend)
sheet 2 di column A1 : "Baseball", Column B1 nilainya 2 (ini mksdnya yg diambil utk category baseball ini cuma sampai account 2)
sheet 2 ( di sheet yg sama dengan yg diatas) memiliki data seperti ini (column C1 : account number, column D1 : email account)
1 | [email protected] |
2 | [email protected] |
3 | [email protected] |
Sheet 3 data nya sbb : (column A1 : Category, A2 : Account number , A3 : Sub Category)
Baseball | 1 | Baseball Mug |
Baseball | 2 | Baseball Gift for Boyfriend |
Baseball | 3 | Baseball Gift for Parents |
Baseball | 4 | Baseball Mug for Son |
Baseball | 1 | Baseball Gift |
Baseball | 2 | Baseball Gift for Girlfriend |
Baseball | 5 | Baseball bat gift |
Baseball | 5 | Baseball Hat Gift |
Baseball | 6 | Baseball shoes gift |
Baseball | 6 | Baseball Shoes for Boyfriend |
Nanti hasil nya ada di sheet 1 column B1,sprti ini hasilnya :
[email protected] (baseball mug,baseball gift)|
[email protected](baseball gift for boyfriend, baseball gift for girlfriend)