look in the help index for TRANSPOSE

--
Don Guillett
SalesAid Software

"Biller" wrote in message
...
I have exported information from our billing system and it has put each
individual item as a separate line item in a single column. For all items
belonging to the same customer, I need them to be on the same line. (ie
line
1, column a, column b, column c etc. ) in order to merge them into a
letter
in a word document. Is there an easier way than cutting and pasting each
item in the row to the next column?