I have an excel sheet having 2D data which I want to store in my datawarehouse with a one to one relationship between the attributes in the row and column. I want to store these two things in two different tables in my datawarehouse.

Sno. '0000100001000110' '0000000000011100' '0000000010000101000001100' '0000010000010000000101100'
1 0 0 0 0
2 0 0 0 0
3 0 0 0 0
4 0 0 0 0
5 0 0 0 0
6 0 0 0 0
7 1 4 0 1
8 1 4 0 1
9 1 4 0 1
10 3 6 0 3