Hi Experts,
I have one requirement in which i need to convert row wise data to column wise data. for first instance it looks easy but.. i not getting way to resolve it..
My input file is:
| Key1 | WBS | Name | Key2 |
| 314 | 0 | ABC | 1344 |
| 314 | 1 | ABC | 1423 |
| 314 | 1.1 | ABC 2.5 | 1502 |
| 314 | 1.1.1 | ABC 2.5 - Android | 1581 |
| 314 | 1.1.2 | ABC 2.5 - iOS | 1668 |
| 314 | 1.1.3 | ABC 2.5 - Unity | 1755 |
| 314 | 1.2 | ABC 2.6 | 2277 |
| 314 | 1.2.1 | ABC 2.6 - Android | 2356 |
| 314 | 1.2.2 | ABC 2.6 - iOS | 2449 |
| 126410 | 0 | SP140_141 Schedule | 127635 |
| 126410 | 1 | Kingfisher 3.0 (SP140,K22,SP141/4002) | 127717 |
| 126410 | 1.1 | Milestones | 127799 |
| 126410 | 1.1.1 | AJ 3.3.2 Thin Client FC | 127881 |
| 126410 | 1.1.2 | AJ 3.3.2 Thin Client CS | 127977 |
| 126410 | 1.1.3 | About/Config | 128062 |
| 126410 | 1.1.3.1 | About/Config FC | 128144 |
| 126410 | 1.1.3.2 | About/Config CS | 128240 |
| 126410 | 1.1.4 | Notification | 128325 |
| 126410 | 1.1.4.1 | Notification FC | 128407 |
| 126410 | 1.1.4.2 | Notification CS | 128495 |
| 126410 | 1.1.5 | Onboarding | 128580 |
| 126410 | 1.1.5.1 | Onboarding FC | 128662 |
| 126410 | 1.1.5.2 | Onboarding CS | 128751 |
| 126410 | 1.1.6 | Control Panel | 128836 |
| 126410 | 1.1.6.1 | Control FC | 128915 |
| 126410 | 1.1.6.2 | Control CS | 129000 |
and i need to get output like below:
| Key | Task1 | Task2 | Task3 | Task4 | Task5 | Key2 |
| 314 | ABC | ABC | ABC 2.5 | ABC 2.5 - Android | | 1581 |
| 314 | ABC | ABC | ABC 2.5 | ABC 2.5 - iOS | | 1668 |
| 314 | ABC | ABC | ABC 2.5 | ABC 2.5 - Unity | | 1755 |
| 314 | ABC | ABC | ABC 2.6 | ABC 2.6 - Android | | 2356 |
| 314 | ABC | ABC | ABC 2.6 | ABC 2.6 - iOS | | 2449 |
| 126410 | SP140_141 Schedule | Kingfisher 3.0 (SP140,K22,SP141/4002) | Milestones | AJ 3.3.2 Thin Client FC | | 127881 |
| 126410 | SP140_141 Schedule | Kingfisher 3.0 (SP140,K22,SP141/4002) | Milestones | AJ 3.3.2 Thin Client CS | | 127977 |
| 126410 | SP140_141 Schedule | Kingfisher 3.0 (SP140,K22,SP141/4002) | Milestones | About/Config | About/Config FC | 128144 |
| 126410 | SP140_141 Schedule | Kingfisher 3.0 (SP140,K22,SP141/4002) | Milestones | About/Config | About/Config CS | 128240 |
| 126410 | SP140_141 Schedule | Kingfisher 3.0 (SP140,K22,SP141/4002) | Milestones | Notification | Notification FC | 128407 |
| 126410 | SP140_141 Schedule | Kingfisher 3.0 (SP140,K22,SP141/4002) | Milestones | Notification | Notification CS | 128495 |
| 126410 | SP140_141 Schedule | Kingfisher 3.0 (SP140,K22,SP141/4002) | Milestones | Onboarding | Onboarding FC | 128662 |
| 126410 | SP140_141 Schedule | Kingfisher 3.0 (SP140,K22,SP141/4002) | Milestones | Onboarding | Onboarding CS | 128751 |
| 126410 | SP140_141 Schedule | Kingfisher 3.0 (SP140,K22,SP141/4002) | Milestones | Control Panel | Control FC | 128915 |
| 126410 | SP140_141 Schedule | Kingfisher 3.0 (SP140,K22,SP141/4002) | Milestones | Control Panel | Control CS | 129000 |
Please help me out to get the solution.
Thanks in Advance
Regards
Sushil
