Vertical Concatenate function
The big question here is when you are looking at the data, how do you
identify how many rows for each ticket. Is there blank cell between them or
something?
It might require a macro but there must be a way of identifying where one
finishes and the next one starts even if it is in another column. Perhaps a
sample of your data for a couple of tickets will help.
Regards,
OssieMac
"rr94527" wrote:
Hello, I have rows of data that needs to be concatenate together to form one
nice long string. Each row has a number assigned to it. Lets call it ticket
number.
Ticket number 1 has 4 rows of data that needs to be concatenate.
Ticket number 2 has 7 rows of data that needs to be concatenate.
How do I concatenate tickets that does not have a fixed number of row?
I tried using pivot table to count the number of rows each ticket has. Now
that I know, how can tell excel that this ticket has 4 rows to concatenate,
that ticket has 7 rows, etc?
A million thanks in advance.
|