Report 如下:
Material A
Factory# of material A
Material B
Factory # of material B
Factory # of material B
Material C
Factory # of material C
Factory # of material C
Factory # of material C
所以我希望在excel令到個report變成如下:
Material AFactory # of material A
Material BFactory # of material B
Material BFactory # of material B
Material CFactory # of material C
Material CFactory # of material C
Material CFactory # of material C
更新1:
Old: A 1 Material A 2 Factory# of material A 3 4 Material B 5 Factory # of material B 6 Factory # of material B New: A B 1 Material A Factory # of material A 2 Material B Factory # of material B 3 Material B Factory # of material B