I have a table like this.

Name Status 1 Action 1 Status 2 Action 2 Status 3 Action 3
AAA Started S Pended P Closed C
BBB Started S Pended P Closed C
CCC Started S Closed C

I need the output like below, it has seq no generator in output.

Name Status Action Seq No
AAA Started S 1
AAA Pended P 2
AAA Closed C 3
BBB Started S 1
BBB Pended P 2
BBB Closed C 3
CCC Started S 1
CCC Closed C 2

Not able to do this using unpivot.

Not able to do this using unpivot.