Hi,
Welcome to Tek-Tips.
We need more information. I don't know if your problem is in Crystal Reports or in Excel.
If Excel is where the transposition "should fit in a single row" then this thread ought to be posted in Forum68.
How many rows are in the "multiline address field in crystal reports header section"?
Is that number of rows the same for every header every time? For instance might it always be...
Name
Street address
City, State Zip
...3 header rows transposed to 1 Excel row...
But then the question remains, how many columns? 1, 3, 5?
Could the header address SOMETIMES be 4 rows or 2 rows?
Inquiring minds want to know.
BTW, reports are TERRIBLE sources for data analysis, generally speaking. I almost always start looking for source data, but I know that not always possible.
BTW2, an EXAMPLE would be very helpful.
Skip,
Just traded in my OLD subtlety...
for a NUance!![[tongue] [tongue] [tongue]](/data/assets/smilies/tongue.gif)
"The most incomprehensible thing about the universe is that it is comprehensible" A. Einstein
You Matter...
unless you multiply yourself by the speed of light squared, then...
You Energy!