I have this data sample :
Name Status Bank XXXX Active BankA XXXX Hold BankB
How can I make something like this ?
Name Status 1 Bank 1 Status 2 Bank 2 XXXX Active BankA Hold BankB