3
I have a spreadsheet that looks something like this:
A B C D E ...
1| 1 0 0 1 0
2| 0 1 0 0 1
3| 0 0 0 1 0
4| 1 0 0 0 0
I'd like to concatenate row 1 in column F so that it returns: 10010
But entering =concatenate(A1:E1)
returns an error #VALUE!
and using an array formula ({=concatenate(A1:E1)}
) returns just 1.
This method gets me close, but it removes the formula so I can't drag down and concatenate all rows.
Why does Excel make concatenating so hard? Is there another way to do this without using VBA?
I do have lots of columns. Of course I do! I'll mark this correct unless there's a deus ex machina of an answer in the next couple days. – samthebrand – 2015-02-25T20:57:58.350