manojk71273
Board Regular
- Joined
- Apr 28, 2006
- Messages
- 115
- Office Version
- 365
- Platform
- Windows
Hi All
I have Data in following fashion
Columns A B C D
1 0 2 0
0 1 0 2
0 0 1 2
0 0 0 1
you can get the combinations from the above table. (the figures represents the amounts)
Now I want to take the data in another sheet by ignoring the zeros in the following way
A B
abcd 1 (FIGURE FROM A1)
xyz 2 (FIGURE FROM C1)
A B
abcd 1 (FIGURE FROM B1)
xyz 2 (FIGURE FROM D1)
SO ON & SO FORTH
how can i do the above thing
Thanks in advance to all
regards
manoj
I have Data in following fashion
Columns A B C D
1 0 2 0
0 1 0 2
0 0 1 2
0 0 0 1
you can get the combinations from the above table. (the figures represents the amounts)
Now I want to take the data in another sheet by ignoring the zeros in the following way
A B
abcd 1 (FIGURE FROM A1)
xyz 2 (FIGURE FROM C1)
A B
abcd 1 (FIGURE FROM B1)
xyz 2 (FIGURE FROM D1)
SO ON & SO FORTH
how can i do the above thing
Thanks in advance to all
regards
manoj