I am trying to manipulate a bunch of string elements I have put in columns in Excel. I then filled the preceding column with data, and then the following column as well. Now I want to delete the column boundaries, leaving one column with the data from all the columns in that one. Like so:
A B C 1 @ # @ 2 @ # @ 3 @ # @
And I want it to look like this:
A B C 1 @#@ 2 @#@ 3 @#@
The actual names of the columns and rows are irrelevant, I think, but they are adjacent.