1 of 1 people found this helpful
Option 2 is the best approach if you can do that. An ETL tool would help (especially if you have to do this frequently and not just a one-off). Alteryx would be my choice, but you can also try Knime or Informatica Rev.
Even if it's a one-off, Alteryx on a 14day free trial would do it (watch out though, Alteryx is as addictive as Tableau )
Let me know if you need more help
Wow - thanks.
Ill have a play this weekend!!!!