Transpose Table same Index

[Tommy23]

Hello 

I have this table as Input:

Source.NameColumn1Column3

1.pdf	Findings	Alert Status
1.pdf	Company Information Associated with Individual	No information available
1.pdf	Sanctions, Enforcements and Watchlists	Not Alerted
1.pdf	Politically Exposed Persons	Risk Alert
1.pdf	Corruption	possible
1.pdf	Others	Not Alerted
2.pdf	STRICTLY CONFIDENTIAL STRICTLY CONFIDENTIAL	Yes
3.pdf	Findings	Alert Status
3.pdf	Company Registry Status	Found
3.pdf	Sanctions, Enforcements and Watchlists	Risk Alert
3.pdf	Politically Exposed Persons	Risk Alert
3.pdf	Corruption	Risk Alert
3.pdf	Others	Could Alerted

I would  like to transform this table into this:

Name	Findings	Company Information Associated with Individual	Sanctions, Enforcements and Watchlists	Politically Exposed Persons	Corruption	Others	STRICTLY CONFIDENTIAL STRICTLY CONFIDENTIAL	Company Registry Status
1.pdf	Alert Status	No information available	Not Alerted	Risk Alert	possible	Not Alerted	NULL	NULL
2.pdf	NULL	NULL	NULL	NULL	NULL	NULL	YES	NULL
3.pdf	Alert Status	NULL	Risk Alert	Risk Alert	Risk Alert	Could Alerted	NULL	Found

I try to used the "Transpose" tools without success. I would like the workflow to be running even if the value inside third column is different.  I will be using this workflow for multiple "Name" with multiple column, indeed it will not only be the column present is this example but also others column.

I would like to thank you in advance

[DataNath · Accepted solution]

Hey @Tommy23, how's this? You'll need to be looking at Cross-Tab here rather than Transpose - the latter would be if you were going from your desired output to your input:

If you're precious about the record/field order then there needs to be a bit of extra work to maintain that so let us know.

[RobertOdera · Accepted solution]

Hi, @Tommy23 

Here you go.

The formula in the Dynamic rename tool is: TitleCase(TRIM(Replace([_CurrentField_], '_', ' ')))

Please mark it as an acceptable solution if it works for you. Cheers!

[Tommy23]

Thanks a lot @DataNath  and @RobertOdera  It was really helpfull

[RobertOdera]

You're most welcome @Tommy23