View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Utkarsh Utkarsh is offline
external usenet poster
 
Posts: 18
Default Transpose problem

Hi

I have data organised as:

A 1 2 3
B 4 5
C 6 7
I want to rearrange it as:
A 1
A 2
A 3
B 4
B 5
C 6
C 7

The standard transpose doesn't help. I guess this will have to be done
programatically. Can someone help?

Thanks
Utkarsh