Kevin,
Note the total number of rows in your Raw Input sheet, then try this:
• In the first column of your second worksheet, enter the digit 1 in A1 then
enter the formula "=A1+4" in A2. Then start from A2 selecting down with
shift-down arrow until VO announces that you've selected the correct
Thanks Tim. One more question for anyone else on this thread.
The method you mentioned is great for a list, however, what I need to do is
convert four line blocks of text into four columns.
In other words, I need to convert:
Bananas
No Doubt
Columbia Records
Sony Music Inc.
Get Lucky
Daft Punk
Hi,
How about you try this in TextEdit:
1. Open the document.
2. Make sure the document is in Plain Text from under the Format menu.
3. Press cmd-f to bring up the Find dialog.
4. In the Find field, press Option-return. That's pressing the return key
while the Option key is down.
5. In the
Hi,
I'm wondering if anyone knows of a way to convert columnar text in a Pages or
TexEdit document into a Numbers spreadsheet, however I need the lines of text
to be converted into columns.
For example:
Bananas
No Doubt
Columbia
Sony Music Inc.
should be converted to:
Bananas No Doubt
