Transpose partial the table and generate new columns

[ahsankhalid]

Hello Community, 

I have a dataset of applicants and would like to transpose.

I need to repeat the 1st 5 columns times each measure the applicants applied for. 

Please can someone help. 

[DavidP · Accepted solution]

If you set the 1st 5 columns as key fields in the transpose tool, they don't get transposed and will repeat for every column that does get transposed.

It's difficult to build a solution if you just provide a screenshot. If you can paste some sample data as a table, we can help you much easier.

[Jonathan-Sherman · Accepted solution]

Hi @ahsankhalid,

This would involve a simple transpose with Lot, WS, Area, Company and Value Band being ticked as "key columns" (in other words columns NOT to pivot") and the others being ticked as "data column" (columns TO pivot):

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

[ahsankhalid]

Apologies @DavidP. I think I missed the attachment.