Need Help: how to convert row wise data to column data.

[sushil353]

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

[Gysbert_Wassenaar · Accepted solution]

See attached qvw