View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
OssieMac OssieMac is offline
external usenet poster
 
Posts: 2,510
Default 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.