table totxt

[Guest]

I have a table as follo
1 2 3 4
A +
B + +
C + + +

How can I get saved on a txt file the following interpretation of the tabl
A
B 2,
C 1,3,4,

Thanks

 

[Dave Peterson]

I'd this (against a copy of the data!):

Select your range
Edit|goto|special
constants
ok

This should select all your +'s (if the +'s are the results of a formula, then
Edit|paste special|values, first)

then type:
=column()

and hit control Enter.

This should fill all those cells with the number of the column that they're in.

Then use a helper cell (F1) and use this formula:
=IF(A1="","",A1&",")&IF(B1="","",B1&",")&IF(C1="","",C1&",")
&IF(D1="","",D1&",")&if(e1="","",E1&",")

You'll end up with:
2,3,
Now use another helper cell (G1) and use this formula:
=IF(F1="","",LEFT(F1,LEN(F1)-1))

Drag both formulas down the table.

Now select that last column (G) and copy|paste into notepad.