| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
table to single row
The following formula works well to convert a table of multiple dimensions (here four columns) to just one column (in the order i would like which is across the first row of data, starting again with the first value of the second row):
=OFFSET($A$1,MOD(ROWS($1:1)-1,4),INT((ROWS($1:1)-1)/4)) How can you use a similar function to return the table as one row instead of one column? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert table to a single column | Excel Discussion (Misc queries) | |||
| Convert table to single column | Excel Discussion (Misc queries) | |||
| Tax Table Formula in Single Cell | Excel Programming | |||
| pivot table single choice | Excel Discussion (Misc queries) | |||
| pivot table single column | Excel Programming | |||
Threaded Mode
