I have a CALC sheet that has 2 cols (STATES an COUNTIES) that I would like to permently connect so that they cannot be sorted separetly.
Possible ?
Thanks,
⌡im [THE BookMan]
920.265.5966
Put both data in the same cell (with TEXTJOIN in an auxiliary column).
Why do you need them in separate columns?
I thought, why not fuse the data into arrays with something like:
Function Fuse2(Cell1, Cell2)
Fuse2 = Array(Cell1, Cell2)
End Function
To my surprise, even if the horizontal arrays of two cells would be sorted together as rows in a data sort, apparently you cannot sort array results at all??
Don’t teach him bad things.
It is very easy to mismatch data in spreadsheets. Being attentive and not doing it is the first necessary skill. And everything you suggest assumes the OP’s inability to learn this skill. But that’s not true, is it?
Not inserting blank rows (and columns) is the second necessary skill.
1 Like
And…just today from an established professional site I had to use a quoted string format for data export because the City, State, and ZIP were are in one field and comma separated…
This is the most basic feature of a database that you can not tear apart the columns of a table.
US_States_Counties.odb (168.6 KB)
It is impossible. It’s your task not to separate the data. However, Calc will offer to select the entire contiguous range of data (or press Ctrl+*).
2 Likes