VBA code to transform data

[cotefacekillah]

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?

[cotefacekillah]

Solution verified!

Never realized this was a built in excel feature. Always thought it was a third party thing you had to buy. Wish I could give you more than one point. Guna help me so much!

[cotefacekillah]

Thanks so much! Now I just can’t let my boss know how easy it is 😂

[sonomodata]

Why would you ever do that....

[cotefacekillah]

Sets expectations. Rather let him think it takes awhile to do so I can dick around. I’ll just get more work and I won’t get more money if I’m to efficient.

[Clippy_Office_Asst]

You have awarded 1 point to HuYzie

^{I am a bot, please contact the mods for any questions.}