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.1.jpg2.jpg
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 (attachement 2)
Bookmarks