Hi all
I have data in wide format i.e col with three variables: predicted, upper and lower and respective rounding options like round up of predicted, upper and lower, round down of predicted, upper and lower etc. which I want to reorganize it in long format i.e some constant rows like date and all of the value has to be reformatted into longer.
I have attached the " have" and "want" data.
Any help is highly appreciated.