Hi guys,
I have a problem with data transformation from rows to columns. Since I am a bit familiar with excel the going to option would be PIVOT. But my one seems to be a special case and I can't find any solution by searching google and the search function here in this forum. Mostly because I do not know how to describe the problem in a proper way to look it up.
NOTE to MODERATOR: If the PIVOT function can't handle this, please feel free to move this post.
Let's start with an example:
I got a file which I have to work on and process the data.
The problem is the data is ordered like this:
I need it to look like this:
I have tried PIVOT but that only gives me the rows of the diffrent values in column B as single columns with the values as column names back.
Like this:
Maybe there is another option to switch it in PIVOT but I can't find it. I have never had to deal with such a file before and do not know how to modify it to my needs.
I tried the transpose option (when pasting it) too but the same result...
It looks like there is no one that has to deal with this sort of data. I can find a bunch of information about the "classical" data for PIVOT like shown below but no one like the one I have got.
Classic case of PIVOT to "turn data around":
I really appresciate your help.
Thank you,
matt
Bookmarks