Transpose column data every 9 cells

sunshinevivi - Feb 20, 2009 at 04:47 PM
I have 2 columns to transpose. The column A contains Date1..Date9..repeated. The column B contains the data I need.

Country xxxx
State asas
ZIP code eirei
Country bnnn
State mmm
ZIP code eirei

The transpose fields is repeating every 9 lines.
I try to select 9 cells, and using this formula {=TRANSPOSE(B1:B9)} and press CTRL+SHIFT+ENTER. It works, but this is occuring every 9 lines and so on.
Help me please. Thanks :)