hugo_17_23 19942 (10/18/2012)
Can Anyone help me with this, please
I have a Table like this
Es Year January February March
E0003 2008 XXXXX XXXXX XXXXX
E0003 2009 XXXXY XXXXY XXXXY
E0004 2008 XXXYY XXXYY XXXYY
E0004 2009 ZZYYY ZZYYY ZZYYY
And I need to convert that table into this:
Es Jan_08 Jan_09 Feb_08 Feb_09 Mar_08 Mar_09
E0003 XXXXX XXXXY XXXXX XXXXY XXXXX XXXXY
E0004 XXXYY ZZYYY XXXYY ZZYYY XXXYY ZZYYY
You will need to "unpivot" or "uncrosstab" the data so that it's in a vertical format and then "repivot" or "recrosstab" to the desired layout.
For coded help, please see the first link in my signature line below.
As a sidebar, the original data is stored as if it were a spreadsheet, which is a denormalized form and causes a lot of the problems like the very problem you're currently having. My recommendation is that once you have "unpivoted" the data, you keep it that way.
is pronounced ree-bar and is a Modenism for R
First step towards the paradigm shift of writing Set Based code: Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column.
Although they tell us that they want it real bad, our primary goal is to ensure that we dont actually give it to them that way.
Although change is inevitable, change for the better is not.
Just because you can do something in PowerShell, doesnt mean you should. Helpful Links:
How to post code problemsHow to post performance problemsForum FAQs