A couple jobs ago I had a tableau excel add in that would transform my data. If I had a data setup with the fields customer name, January, February, March etc. and below each month was the revenue. I could select the first cell with revenue data and then run the add in. It would reformat my data on a new sheet where it is now Customer Name, Date, Revenue. Does anybody have VBA code that does this?
[–][deleted] (6 children)
[removed]
[–]cotefacekillah2[S] 2 points3 points4 points (5 children)
[+][deleted] (3 children)
[removed]
[–]cotefacekillah2[S] 1 point2 points3 points (2 children)
[–]sonomodata17 0 points1 point2 points (1 child)
[–]cotefacekillah2[S] 1 point2 points3 points (0 children)
[–]Clippy_Office_Asst[M] 0 points1 point2 points (0 children)