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.
Solved! Go to 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.
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
Apologies @DavidP. I think I missed the attachment.