View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Demosthenes Demosthenes is offline
external usenet poster
 
Posts: 36
Default Transpose Multiple Rows to one

Hello,

I'm trying to change the format of my data. Ex:

apple 2
ab cd
orange 5
ef gh
banana 4
cd ef

And I want to get it to the format:

apple 2 ab cd
orange 5 ef gh
banana 4 cd ef

Is there an easy way to do that? I can't figure it out with transpose or the
offset function.

Thanks!