Transpose individual dates from header to single column
I'm trying to create a pivot table which will include LOB as column headers and Dates in rows. However, my raw data has Date in the column header instead
First attachment is what my goal is, while 2nd attachment is my current raw data. Is there any way I can achieve the pivot table that I want. If not, what's the most convenient and efficient way of manually recreating the Raw (attachment 2)1.jpg2.jpg
HOW TO ATTACH YOUR SAMPLE WORKBOOK:
Fast answers need clear examples. Post a small Excel sheet (not a picture) showing realistic & representative sample data WITHOUT confidential information (10-20 rows, not thousands...) and some manually calculated results. For a new thread (1st post), scroll to Manage Attachments, otherwise scroll down to GO ADVANCED, click, and then scroll down to MANAGE ATTACHMENTS and click again. Now follow the instructions at the top of that screen.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Will do. Thank you!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks