Data to be converted in vertical form populating unique values

[[email protected]]

Good Afternoon Everyone.


Below is data to be be Converted into vertical form.

ATM ID FUALT1 FAULT2 FAULT3 CASE1 CASE2 CASE3
1 0 1 0 2 2 1
2 1 1 0 9 2 6

Need result in below format.

ATM ID Faults Cases
1 0 2
1 1 2
1 0 1
2 1 9
2 1 2
2 0 6

Thanks & Regards

Kapil

[adyteo]

copy:
1 0 1 0 2 2 1
2 1 1 0 9 2 6

Paste Transpose

[MickG]

Try this:-
Results start "H1"

Please Login or Register  to view this content.

Regards Mick