Get Started: AI Resources for Oracle Cloud HCM – Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Multiple Rows to Columns, from different Field
Summary
Conver multiple rows into columns where the rows are generated by more than one fieldContent
HI
I want to convert multiple columns to rows, I'm trying to use pivot table, however I'm only able to convert to rows the information related to one field of the database, but I have more than 1 field to convert to rows.
My original data looks like this:
| Person Number | NIT ID | NIT VAL | Type | Type value |
| 10019134 | AD Number | 52278 | DHL Provident Fund No. | 6699 |
| ESIC No. | 0100 | |||
| NPS No. | 9999 | |||
| PAN Card Name | 535D | |||
| Previous Employer Provident Fund No. | 5549 | |||
| PER ID | 8643N | DHL Provident Fund No. |
Tagged:
0