Need a New Row at Every Instance of a Certain Character (or every X columns)

Yes, it can be done. Can you post an example file in the format you have so we can play about with it? (The FAQ describes how, but it is similar to posting your jpeg files).

Is the data only on row 1 to start with? Do you always have the same number of columns, if in multiple rows?

Pete

Greetings Pete!
Thank you for offering a hand!
Here is a sample file (the first record repeated thrice): Sample_NewRows_8-15-13.xlsx

The data pastes into Excel as multiple rows in one column, but I have transposed it once. If that original format would work better, let me know.

And yes, each record has a stable number of columns, 9. So the first record is A1:I1, second record is J1:R1, etc.

Put this formula in A1 of a new sheet:

=IF(OR(COLUMN(A$1)>9,(ROWS($1:1)-1)*9+COLUMN(A$1)>COUNTA(Sheet4!$1:$1)),"",INDEX(Sheet4!$1:$1,(ROWS($1:1)-1)*9+COLUMN(A$1)))

then you can copy across. Use the Format Painter to copy the formats for the first record from your other sheet, and then you can copy the row down as far as you need to. In the attached file I've copied across to column L and down to row 7 to show that you just get blanks if you copy too far.

Hope this helps.

Pete

Ah, so close.
I see how well this works in the sample.
I had failed to realize that any record labeled "I" (incoming) does not have a phone number associated with it, so there are blanks that I did not see. Some records are actually shorter than others.

You have written a very impressive formula here, Pete, but could I ask if you know another way to detect the actual "D" character to denote the next record?

You mentioned in your first post that the data has already been transposed from a single column format. It might be easier to work with that directly, so could you post an example in that format with some representative data?

Pete

Here is a sample of the data vertically, as it pastes into Excel, and also with a shorter Incoming record. Sample_NewRows2_8-16-13.xlsx

Thank you for all of your help so far.