Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have a list of data written in col. say 105 no data in A1:A105
Now I wart to write those 105 data in rows, Each row can have maximun 10 data.The next data (11th) will go to next row. for example wehave data A1=1 A2 =2 A3=13 A4 =12 A5=14 .... .... ... ... .... A105= 25 i want to rearrange those data in the following way say, C1 D1 ..................................... L1 (total 10 data in each row) C2 D2 L2 and so on... Where C1 = A1, D1 = A2,..........................L1= A10 C2=A11, D2 =A12..........................L2=A20 ...................... Hope I can explain properly, Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Rearranging data | Excel Discussion (Misc queries) | |||
rearranging data | Excel Worksheet Functions | |||
Rearranging Data Within a Cell | Excel Worksheet Functions | |||
Rearranging Data in Excel | Excel Discussion (Misc queries) | |||
Rearranging Data Help... | Excel Discussion (Misc queries) |