Any response is gonna depend on what your data looks like.

Are there always x number of rows per group?
Is row 1 of the group always the same field
Same with 2 through X.

If there aren't always the same number of rows per group, is there a gap between
groups?

If there aren't always the same number of rows per group, how do you know which
row of the group goes into what column of the flattened row?

jlbowman wrote:

How would I copy a list of address labels into excel and then get the names,
street addresses and city/state/zip into three seprate columns so as to be
able to sort, etc. without copying the individual label info one at a time (I
have 1800)? When I copy them into Excel, it lists XYZ name in A1, Street into
A2, City into A3. I want A, B, C without having to do them one at a time.
Any suggestions? I'm sorry if this question is too poorly written to
understand...

--

Dave Peterson