Data Preparation, Transpose/Crosstab

[Preet2020]

Hi All,

How do i convert the input to the Desired output format ? I have tried Crosstab and Transpose but it doesn't work, may be i am using some wrong combinations. Looking forward for a solution

INPUT

	GI	BIR`	TC	HPST	BPST	BKPST	CFBP
TOPIO SERVICE	-	-	-	8.33%	-	34%	58%
REPORTING RESER	-	-	100%	-	-	-	-
UK REP REPORTING APPLICATION	-	100%	-	-	-	-	-
UK REGULATORY REPORTING	25%	-	-	-	-	-	-
Capital Planning Forecasting	-	-	-	100%	-	-	-
Impairment	65%	-	-	35%	-	-	-

DESIRED OUTPUT

--------------------------

Tools	LFC	Percentage%
TOPIO SERVICE	GI
TOPIO SERVICE	BIR
TOPIO SERVICE	TC
TOPIO SERVICE	HPST	8.33%
TOPIO SERVICE	BPST
TOPIO SERVICE	BKPST	34%
TOPIO SERVICE	CFBP	58%

[Jonathan-Sherman · Accepted solution]

Hi @Preet2020,

I think the transpose tool will help you with what you're trying to achieve:

If this solves your issue please mark the answer as correct, if not let me know! I've attached my workflow for you to download if needed.

Regards,

Jonathan

[bhrmitra · Accepted solution]

Hi Preet2020,

Transpose Tool will work. Solution Attached

Workflow:-

Output:-

Thanks,

Abhra Mitra