Pivot Without aggregation

[dkhoanguyen]

Hello everyone, I read up on this post regarding pivot without aggregation I want to expand from that. I have 2 columns:
Header Value
CUS John
PRO Banana
QUA 2
CUS Magaret
PRO Orange
QUA 1
PRO Banana
QUA 2
CUS Zack
PRO Banana
QUA 1

I want to create a pivot table that looks like this
CUS PRO QUA
John Banana 2
Magaret Orange 1
Magaret Banana 2
Zack Banana 1

Here is the link to the original post:

Pivot without aggregation

Hi, I have a table that I want to pivot but without doing aggregation of some sort. The input looks like this: Well Value A01 1 A01 2 A01 3 A02 4 A02 5 A02 6 From this I want to generate: A01 A02 1 4 2 5 3 6 So the Well IDs should become new column headers for columns containing all original values for the specific wells. Any tips appreciated!

Here is the file.
I was never able to replicate Magaret in the third row.
Pivoting_in_loop.xlsx (8.4 KB) Pivoting_in_loop_SWF.knwf (21.5 KB)

Thanks,
KN

[beginner]

OK, I see the issue. I though an easy solution was chunk loop start + transpose but due to the weird format this isn’t possible either. I would figure out if you can’t get this data in a more reasonable format. Else I don’t see how to easily achieve a solution without programming (java snippet/python script).

If programming is an option, I would look into that route.

[tommy]

hi @dkhoanguyen,

it’s possible, however, your xls has to provide the corresponding order of rows // cus,pro,qua.
You may use a combination of Pivot (generating lists per cus) and Ungroup. With the following solution you should even be able to avoid loops.

Z_025_unpivot – tommy

Hope that helps, regards, Tommy

[dkhoanguyen]

@tommy

xls has to provide the corresponding order of rows // cus,pro,qua.

Thank you so much. This is exactly what I am looking for.