View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Concatanate odd rows

A - K is 11 columns, A - T is 20 columns, perhaps A - V

--
Regards,
Tom Ogilvy

"Yogi_Bear_79" wrote in message
...
All rows are the same size A~K, once concatanated they should be A~T




"Alan Beban" wrote in message
...
Are your rows all the same size?

Alan Beban

Yogi_Bear_79 wrote:
I need to concatanate the odd rows to the ends of the even rows.

Starting at
row 2. I'd like the filled cells from row 2 to be added to the first

empty
cell in row 1. I'd like this proces to continue to the end of the
spreadsheet.

Once completed I should have 1/2 the original rows