View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
mjmcevoy mjmcevoy is offline
external usenet poster
 
Posts: 5
Default Looping through clumns and switch to rows

I need to convert

Customer B 1457895 1248875 45345345 45345434
Customer X 6548464 6549846 68462184 6548414 6354654


to

Customer B 1457895
Customer B 1248875
Customer B 45345345
Customer B 45345434
Customer X 6548464
Customer X 6549846
Customer X 68462184
Customer X 6548414
Customer X 6354654

It is several lines ad as many as 225 columns per line.

Any help is appreciated.