View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Dawn Dawn is offline
external usenet poster
 
Posts: 80
Default Records re-allocation problem.

Dear all,
Theres a table A in a sheet in excel, in this table ,the records are
placed row byrow,for example,if there are 20 records,then it occupies 1-21
rows(including column heading.)
And I have to use the records in another table B,but the pattern of table B
is for every four rows ,the first equals the one row in table A,and the other
three rows are kept null,for example,(the second row in table B= the second
row in table A;the sixth row in table B= the third row in table A;the tenth
row in table B= the forth row in table A;€¦etc)
How can I relize it?Thanks.
Best regards.
Dawn Wu
Shanghai,China