Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() I have a excel spread sheet that was handed to me that is bascially data dump from a old data base. When they dump the data though is appears to be in a report format which is 60 rows of data for one record and column a1 being th description of the data and the actual data in column a2 as an example The next record starts on row a60 and repeats throughout the dat dump. How can I get the data for each record in a 1 row of 60 colums and then repeat the process for the next recor set. I would think there is some formula that allows to link b2, b62,b122.. to a1,a2,a3 Thanks in advanc -- newbie_hel ----------------------------------------------------------------------- newbie_help's Profile: http://www.excelforum.com/member.php...fo&userid=1507 View this thread: http://www.excelforum.com/showthread.php?threadid=26708 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Linking spreadsheet | Excel Worksheet Functions | |||
Linking 2 spreadsheet using data from the last row of spreadsheet | Excel Discussion (Misc queries) | |||
Linking 2 spreadsheet using data from 1st spreadsheet | Excel Discussion (Misc queries) | |||
Linking spreadsheet | Excel Worksheet Functions | |||
sumif nightmare! | Excel Worksheet Functions |