Hello,
I've got a tricky problem where I'm trying to graph data in a certain way but the data is not in a format to be worked with. The data I'm looking at is exporting from our software tool like this:
Account Modules Implementation Status Account A Module 1, Module 3, Module 5, Module 6 Active, Delayed, Active, On Hold Account B Module 2, Module 3 Active, Complete Account C Module 7 Active Account D Module 1, Module 2, Module 3, Module 4, Module 5, Module 6, Module 7 On Hold, Active, Not Started, Not Started, Active, Active, Not Started
I want to display this data like this:
ImplementationStatus.PNG
I found some tricks to move from individual cells to columns while removing the commas, but then the trouble becomes how to align things for easy counting and graphing.
Any ideas on how to solve this?
Thanks,
-Tom
Bookmarks