Forum Discussion
Need to restructure my data set. Any macro for this?
Hello, I'm working with a large data set that outputs reports grouped by date, with territory values comma delimited in a single cell, as follows: A B 1 Date1 Territ...
you can do it manually.
after separating the territories into different columns, you need to copy the date column in between all the columns. Then you just need to copy the 2nd set of DATE/TERRITORY below the 1st set, then the 3rd set, etc.
then you sort all the sets by territory and date.
you probably will end with many dates without a territory. Those rows you can just delete.
now you just have to make your territory column your first one.