Transpose column data every 9 cells
Last answer on Feb 20, 2009 10:15:32 pm GMT sunshinevivi, on Feb 20, 2009 9:47:08 pm GMTHello,
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 :)
Configuration: Windows Vista Firefox 3.0.6
Best answers for « transpose column data every 9 cells » in :
Worksheet - Cells ShowThe Concept of a Cell
A "cell" is the intersection between a line
(horizontal) and a column (vertical) on a worksheet. Thus, the name of
the line combined with the name of the column gives the cell's
coordinates (the term address is sometimes also...
Spreadsheets - Cell Selection ShowCell Selection
Spreadsheets are powerful tools for working with
data. However, to work with data, it is necessary to have tools to
rapidly choose the required cells.
Line Selection
An entire line can be chosen by clicking directly on the line...
Spreadsheets - Data Entry ShowCell Content
A cell of a worksheet can contain a value or be empty. The value of a cell has two essential characteristics:
a type, which means the intrinsic type of the data. There are generally three types of values:
numeric values, for example...
The same problem like: http://en.kioskea.net/forum/affich 33041 excel help transpose cells by content |
See also Plus
A cell value is equal to system date, get data columb of next sheet- Copy selected multiple row column data cell to other worksheet excel macro vba
- Excel 2007 transpose vertical data to horizontal with varying amount of data
- Excel function that determines if the cell content in one column matches the cell content of the other column
- Excel macro find first blank cell in a column
- Excel macro sort column data
- Excel transpose column to row
- How to cut column data and paste it in row of the file in unix
- How to list items in a column in one cell on excel
- Howto identify between 6 cell & 9 cell battery lenovo
- Look for data in cell if found fill in from other sheet
- Macro for row data to column data
- Macros to extract partial data from cell
- Move column data to start new row in excel
- Transpose column to multiple rows software download free
- Vba excel enter data in cell based
- When writing a new row column data comes automatically in excel
- When writing a new row in excel, column data should come automatically
