Excel function assistance

Support
1

I'm hoping someone can assist with an Excel formula to help crunch my ODK data.

Data is being collected by gender across a variety of nationalities. This means multiple columns within the XLS sheet which I'm trying to now merge into a single column - see attached.

Excel%20function%20-%20text
Excel%20function%20-%20text979×222 29.2 KB

i had a similar issue relating to numereric data but I've solved that problem but simply summing across the columns then copying the sum down through the row.

I'm guessing there is an equivalent method of copying text across using the correctly chosen formula but an hour's googling hasn't thrown up the answer.

Assistance appreciated.

1 Like
2

You could look at this link which will do exactly what you are after. https://stackoverflow.com/questions/20103881/is-there-a-coalesce-like-function-in-excel

1 Like
3

@Paul_Storry Perfect. Thanks for responding so quickly.

4

@Paul_Storry. Belatedly found another of doing this. The concat function does the trick.

=concat(cell:cell)

Admittedly sorting the result involves another step of copying the result using values into another cell but the extra step is minimal.

Posting this update in case it's of use to anyone else.

1 Like