Got a couple of csv files with content like that:
Product ID | ORG | Where | Condition |
---|---|---|---|
123456 | EMEA | UK | 15 |
123456 | EMEA | DE | 16 |
123456 | EMEA | FR | 17 |
123456 | EMEA | IT | 14 |
123456 | EMEA | ES | 12 |
123456 | EMEA | PL | 22 |
123456 | APAC | NZ | 25 |
123456 | APAC | AU | 29 |
123456 | APAC | HK | 14 |
I got 85,000 lines, but only 4963 product id’s
What i am stuck with is, how to transform it this way:
|ProductID|ORG_EMEA_UK|ORG_EMEA_DE|ORG_EMEA_FR|ORG_EMEA_IT|ORG_EMEA_ES|ORG_EMEA_PL|ORG_APAC_NZ|ORG_APAC_AU|ORG_APAC_HK|
|123456|15|16|17|14|12|22|25|29|14|
Bottom line, i need to configure, how to merge Data and also expand the colums in that step. I haven’t got the slightest idea, how to do this.
I do have a lot more columns, which have identical content, on the other hand i might have 25 lines per product, others might only have 5 lines others 85, depending on the content of those 3 columns ORG; Where, Condition, in some files it could have to be created out of 4 or 5 columns…
So, for each uniqe row with the same product ID i would need an additional column to show the data, but those 4963 product id’s might also share the same unique combination of the example…
I hope i was able to put things together correctly
Also, i read this one: Function(s) to merge data, and since i need this flexible, i am wondering, how i would setup everything.
Thanks and best
PS: Couldn’t use screenshots, it won’t allow me.