hello,
i need help. if i have database before on table and want to make into database after. What formulas can I use? is it possible to use VBA? because I have thousands of data.
Thank you..
i need help. if i have database before on table and want to make into database after. What formulas can I use? is it possible to use VBA? because I have thousands of data.
Thank you..
| Book1 | |||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | |||
| 1 | |||||||||||||||||
| 2 | Database before | Database After | |||||||||||||||
| 3 | Gender | Name | Day | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday | ||||||
| 4 | Female | Rey 1 | Sunday | Female | Rey 1 | Rey 2 | Rey 3 | Rey 4 | Rey 5 | Rey 6 | Rey 7 | Rey 8 | |||||
| 5 | Female | Rey 2 | Monday | Female | Rey 8 | ||||||||||||
| 6 | Female | Rey 3 | Tuesday | Male | Cindy 1 | Cindy 2 | Cindy 3 | Cindy 4 | |||||||||
| 7 | Female | Rey 4 | Wednesday | Male | Cindy 5 | Cindy 6 | |||||||||||
| 8 | Female | Rey 5 | Thursday | ||||||||||||||
| 9 | Female | Rey 6 | Friday | ||||||||||||||
| 10 | Female | Rey 7 | Saturday | ||||||||||||||
| 11 | Female | Rey 8 | Sunday | ||||||||||||||
| 12 | Male | Cindy 1 | Wednesday | ||||||||||||||
| 13 | Male | Cindy 2 | Thursday | ||||||||||||||
| 14 | Male | Cindy 3 | Friday | ||||||||||||||
| 15 | Male | Cindy 4 | Saturday | ||||||||||||||
| 16 | Male | Cindy 5 | Wednesday | ||||||||||||||
| 17 | Male | Cindy 6 | Thursday | ||||||||||||||
| 18 | |||||||||||||||||
Sheet1 | |||||||||||||||||
