Hello every body,
I have problem, I want make the pivot data to be un pivot data.
Example :
I have three column data, now I want excel make be one data tobe one line
<tbody>
</tbody>I want this forum help me to solve this with formula in excel.
I have problem, I want make the pivot data to be un pivot data.
Example :
I have three column data, now I want excel make be one data tobe one line
Item | 4-Oct-12 | 5-Oct-12 | Item | Tanggal | |||
Apel | 2 | 1 | Apel | 4-Oct-12 | |||
Beruang | 1 | 2 | Apel | 4-Oct-12 | |||
Mobil | 2 | 3 | Apel | 5-Oct-12 | |||
pena | 1 | 2 | Beruang | 4-Oct-12 | |||
Beruang | 5-Oct-12 | ||||||
Beruang | 5-Oct-12 | ||||||
Mobil | 4-Oct-12 | ||||||
Mobil | 4-Oct-12 | ||||||
Mobil | 5-Oct-12 | ||||||
Mobil | 5-Oct-12 | ||||||
Mobil | 5-Oct-12 | ||||||
pena | 4-Oct-12 | ||||||
pena | 5-Oct-12 | ||||||
pena | 5-Oct-12 | ||||||
<tbody>
</tbody>