Hi, I have data like this, trying to pivot the data but the result is not as expected
wondering to make it expected result and to make macro for it, cause this is my routine task. many thanks before
Hi, I have data like this, trying to pivot the data but the result is not as expected
wondering to make it expected result and to make macro for it, cause this is my routine task. many thanks before
Last edited by egiyogie; 12-22-2020 at 09:08 AM. Reason: Solved
Sorry for different name on pivot result, i've change the name but somehow still show the initial name
Row Labels- Name
Columns- Date
Value- In & Out
Change the count to Max
Format the number to Time
Remove the grand total
Pivot table option > Check 'Merge and center cells with labels'
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks