Transpose column data every 9 cells [Closed]

Report

sunshinevivi - Feb 20, 2009 at 04:47 PM

Hello,
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 :)

Transpose column data every 9 cells
Need to find a data in a column and copy below cell data or add ✓ - Forum - Excel
How to copy data from one cell to another in excel automatically - How-To - Excel
VBA - A macro to remove part of the data contained in cells - How-To - Excel
Multiple column data validation lists in excel - How-To - Excel
How To Auto Transfer Data from Master to Sub Sheets in Excel - How-To - Excel

Transpose column data every 9 cells [Closed]

Your reply

Subscribe To Our Newsletter!