Hy Guys, I have come across a scenario where I am desperately need your help for this as this is an urgent case for me.
Data set looks like this and I need the output like the below.
Could somebody help me with this please?
Hi @psycho, I’m not at my PC this evening but I think if you can upload a spreadsheet with the sample data in your screenshot you will more likely find somebody able to assist.
1 Like
Check what you selected about missing values
i hope you did not click “Remove Missing Values”
if you did , please give another approach to the missing value and run again
This is sample data takbb I cannot upload the whole set of data here as it is not convenient
The first image is the data I have receveid and I have to transform them as per the next image.
Hi @psycho ,
I wasnt expecting you to upload an entire data set i simply meant if you want people to help you then you need to upload sample data (in a form that can be copied/pasted), or be willing to retype it, because otherwise they will have to…
Help people to help you
5 Likes
If you wish to, I still urge you to upload some sample data which will make it easier for people (including me) to assist you.
4 Likes
Hello @psycho,
you got some specific output format there. Take a look at attached workflow example.
DataManipulation.knwf (20.0 KB)
Basically a bit of playing with unpivoting and pivoting together with taking care of row order is needed. Give it a try on your dataset and let us know. There are comments in workflow that should make it easier to understand but if any questions feel free to ask.
As @takbb said sample input data is preferred.
Br,
Ivan
5 Likes
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.