Dear all, i just realize that, after spending alot of time, to my horror, the database that i've been working on for weeks cannot display correctly in PIVOT table because the part of the month doesnt put as it should be. manual re-writing the database is not possible because it involved hundreds of thousands rows 
after trying to do some googling and macro recording, i must admit that i cannot work this out by myself.
i would like to ask dear fellow here, what should i put in my macro, in order to do repetition of :
1. insert new rows
2. copy the rows
3. transpose the row into 1 column in another worksheet
4. move on to the next row
5. rinse and repeat until rows 100.000 something
to make it easier to understand, i have attached to screenshot.
sorry if my English is bad
regards,
Edwin
after trying to do some googling and macro recording, i must admit that i cannot work this out by myself.
i would like to ask dear fellow here, what should i put in my macro, in order to do repetition of :
1. insert new rows
2. copy the rows
3. transpose the row into 1 column in another worksheet
4. move on to the next row
5. rinse and repeat until rows 100.000 something
to make it easier to understand, i have attached to screenshot.
sorry if my English is bad
regards,
Edwin
Last edited:
