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 number of
rows. That is, if there are 1000 rows in the Raw Input Sheet, you need to hear
VO say "249 Rows Selected". One less than a quarter due to only selecting from
A2 on. This process should place the numbers 1, 5, 9, 13 and so on within
column "A" of your sheet.
• Next, we'll pretend that there are 1000 rows in the Raw Input Sheet. In cell
B1 of your second sheet, enter the formula "=index(Raw Input::Table
1::$a$1:$a$1000,a1)". What this should do is tell NUmbers to look at the first
row of Raw Input, Table 1 for a value and place it into cell B1.
• For cell C1, enter the formula "=index("Raw Input::Table
1::$a$1:$a$1000,a1+1)". This tells Numbers to look at row 2 for this entry.
• For cell D1, enter the formula "=index("Raw Input::Table
1::$a$1:$a$1000,a1+2)". This tells Numbers to look at row 3 for this entry.
• For cell E1, enter the formula "=index("Raw Input::Table
1::$a$1:$a$1000,a1+3)". This tells Numbers to look at row 4 for this entry.
• Now, you should be able to use the Insert menu, Fill Down for each of columns
B, C, D and E individually. For example, for Column B, go to cell B1 then hold
down your shift key and arrow down until you've selected 250 rows as announced
by VO. Go up to the Insert menu, down to Fill and over and down to the "Down"
to Fill this formula down the rest of the column. All your song titles should
appear in this column.
• Do the same process for each of the other three columns and you should get
your desired result.
Note that you won't be able to delete the items in the Raw Input Sheet because,
if you do, all the data is gone and thus you're referencing cells that are
empty.
Hope this helps and sorry if I typed any errors in the syntax of the
Sheet/Table/Cell REferences.
Good luck.
Later...
Tim Kilburn
Fort McMurray, AB Canada
On 2013-04-20, at 2:42 PM, Kevin Shaw <tvsound...@gmail.com> wrote:
> 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
> Columbia Records
> Sony Music Inc.
> Heartbroken
> Meaghan Smith
> Capitol Records
> Warner Music/BMG
>
> to:
>
> Bananas No Doubt Columbia Sony Music INc.
> Get Lucky Daft Punk Columbia Sony Music Inc.
> Heartbroken Meaghan Smith Capitol Warner/BMG
>
> and so on.
>
> What I've done is pasted everything as a single column in my first worksheet
> which I've called Raw Input.
>
> In my second sheet, I've put a formula in to reference the Raw Input sheet
> and cell that I need. So, in the prior example, all song titles are listed
> like this:
> =Raw Input:Table 1:A1
> =Raw Input:Table 1:A5
> =Raw Input:Table 1:A9
>
> In the next column, I've reiterated the process, however starting at A2 and
> going every 4 cells.
>
> I'm wondering if there's a formula to automate this process, like telling
> Numbers to fill down the column with every nth cell. If there's a way to do
> this, I'd save myself lots of time!
>
> Thanks,
> Kevin
>
> On 2013-04-20, at 4:29 PM, Tim Kilburn <kilbur...@gmail.com> wrote:
>
>> 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 Replace field, press Option-tab. That's pressing the tab-key
>> while the Option key is down.
>>
>> What this does is look for return characters and replace them with tab
>> characters. Now when you import this into Numbers, it will place the items
>> horizontally instead of vertically.
>>
>> The issue that may arise though, is that if you use the Replace All
>> functionality, the entire document will go across the Spreadsheet in columns
>> which may not be your desired result. What I'd do to fix this, is search
>> for the key words like "Incorporated" in "Sony Music Incorporated" then
>> replace the tab in that case with a return. You may wish to search for the
>> exact phrase, not just "Incorporated" so that things like "Frustrated
>> Incorporated" or "Pop Music" do not confuse your replacing operation. Using
>> this method, it should be able to essentially, divide these into groups so
>> that those four items are placed in a row then the next song or item is
>> placed within the next row. You'll need to do this in the order I've
>> mentioned here as the tabs must be created first then the return dividers
>> second.
>>
>> Hope this makes sense.
>>
>> Later...
>>
>> Tim Kilburn
>> Fort McMurray, AB Canada
>>
>> On 2013-04-20, at 1:17 PM, Kevin Shaw <tvsound...@gmail.com> wrote:
>>
>>> 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 Columbia Sony Music Inc.
>>>
>>> This way, each line maps to a column in Numbers.
>>>
>>> I'd hate to have to do this the long way.
>>>
>>> Thanks,
>>> Kevin
>>>
>>> --
>>> You received this message because you are subscribed to the Google Groups
>>> "MacVisionaries" group.
>>> To unsubscribe from this group and stop receiving emails from it, send an
>>> email to macvisionaries+unsubscr...@googlegroups.com.
>>> To post to this group, send email to macvisionaries@googlegroups.com.
>>> Visit this group at http://groups.google.com/group/macvisionaries?hl=en.
>>> For more options, visit https://groups.google.com/groups/opt_out.
>>>
>>>
>>
>>
>> --
>> You received this message because you are subscribed to the Google Groups
>> "MacVisionaries" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to macvisionaries+unsubscr...@googlegroups.com.
>> To post to this group, send email to macvisionaries@googlegroups.com.
>> Visit this group at http://groups.google.com/group/macvisionaries?hl=en.
>> For more options, visit https://groups.google.com/groups/opt_out.
>>
>>
>
>
> --
> You received this message because you are subscribed to the Google Groups
> "MacVisionaries" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to macvisionaries+unsubscr...@googlegroups.com.
> To post to this group, send email to macvisionaries@googlegroups.com.
> Visit this group at http://groups.google.com/group/macvisionaries?hl=en.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
--
You received this message because you are subscribed to the Google Groups
"MacVisionaries" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to macvisionaries+unsubscr...@googlegroups.com.
To post to this group, send email to macvisionaries@googlegroups.com.
Visit this group at http://groups.google.com/group/macvisionaries?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
