Hi all,
I have to deal with some very messy data from anaother system (structure therefore fixed).
Its basically many data sets together one below the other. One data set conatins of a Name (ID) and two columns with dates and respective values.
What I am trying to achieve is toe cross tab each data set, so that a have the ID in the first column and the dates as headers with the respective values below.
I attached a sample of data (input and desired output in the other tab).
It is easy for me cross tab one data set. But in reality there or not just 6 (like in my attached sample) but almost 1.000, which means I would have to manually seperate all 1.000 data sets and cross tab each.
Does anyone have any suggestion how to to this autoimatically? :)
