4
If I am using the Text to Columns feature on the following data, using ";" as a delimiter:
foo;bar;qux;baz;toast;
quux;jam;beans;
I'll end up with the results "left aligned" in the resulting grid of cells:
|foo |bar |qux |baz |toast |
|quux |jam |beans | | |
However, I want them to be "right aligned":
|foo |bar |qux |baz |toast |
| | |quux |jam |beans |
How can I do this?
NOTE: I know that "right-aligned" might not be the correct term, instead implying
| foo| bar| qux| baz| toast|
| quux| jam| beans| | |
but this isn't what I'm seeking. So, if anyone can suggest a better term for what I'm describing, please do so.
Addendum: As an alternative approach, if anyone knows a way to use Excel to rearrange cells such that
|a |b |c |d | | | | | |
|n |m |o |p |q | | | | |
|e |f |g |h |i |j |k |l | |
|n |m |o |p |q | | | | |
|x | | | | | | | | |
becomes
| | | | | |a |b |c |d |
| | | | |n |m |o |p |q |
| |e |f |g |h |i |j |k |l |
| | | | |n |m |o |p |q |
| | | | | | | | |x |
then that would also work.
missing cell was a typo – Some_Guy – 2015-06-10T10:31:01.667
And as for your second question, text to columns is a feature that already exists, and outputs the split delimited text line by line, giving each record its own cell in a left to right manner (try it)
I wish to output the data in cells in a right to left fashion. If you are asking me how to command excel to do this then you're asking what I'm asking in the question... – Some_Guy – 2015-06-10T10:32:53.700
For a delimited dataset with variable character lengths where the length of each row is given by k and the length of the longest row is given by n.
The value in the kth column should go into the nth column, the value in the k-1 th column should go in the n-1 th column, etc. If you think this is not clear by extrapolation from the question, please tell me. In my experience people prefer examples to a rigorous definition. I've tried to make the question clear as possible, I'm just unsure what the correct terminology for what I need is. Alignment seems closest. – Some_Guy – 2015-06-10T10:54:03.977
Thanks, that's pretty clear. The whole "toast" thing got me off to a bad start. – Scott – 2015-06-10T11:12:25.443
Yeah, that was my bad. Hopefully someone will have some ideas :/ Maybe a custom sort row-wise that only sorts blank vs not blank, treats rows independently and doesn't alphabetize? Wait come to think of it that sounds ugly, impractical and unworkable :( – Some_Guy – 2015-06-10T11:32:08.377
No, you can't "text-to-columns" fill right-to-left as a standard text to columns function in excel. You'll need vba after the text to columns, or you'll need to use a series of formulas. – Raystafarian – 2015-06-10T11:45:09.930
How about "left-stacked" and "right-stacked" as alternatives to "-aligned"? – hBy2Py – 2015-06-10T18:05:28.057