Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Variable Transposing
I hope there is a solution to this... Basically I am looking to convert a database from the format below into a 'horizontal' Excel database. Only problem being I want each row to contain: a) the first 9 values in the first row b) then the next 3, c) then the next 15 d) then the next x sets of 52 values where x is the number shown at the end of the 15 (23 in this case) Code: -------------------- israeli 5 7 4 5 92 3 0 2 division ligat ha'al 12 teams beitar jerusalem b. jerusalem 8 0 0 5 5 9 5 0 9 9 5 9 23 -------------------- I'm not hopeful, and sense ridicule as I am not using all the 'lingo' you guys do, but any help would be much appreciated! -- NickG ------------------------------------------------------------------------ NickG's Profile: http://www.excelforum.com/member.php...o&userid=33865 View this thread: http://www.excelforum.com/showthread...hreadid=536429 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Variable Transposing
Can I assume that this isn't possible and we'll have to look to change the general format of the database? -- NickG ------------------------------------------------------------------------ NickG's Profile: http://www.excelforum.com/member.php...o&userid=33865 View this thread: http://www.excelforum.com/showthread...hreadid=536429 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Aling multiple sets of data by header column | Excel Discussion (Misc queries) | |||
Variable Names in Formulas | Excel Discussion (Misc queries) | |||
variable height variable width stacked bar charts | Charts and Charting in Excel | |||
why is it saying sheetcnt is "variable not defined" how to do a global variable to share over multiple functions in vba for excel? | Excel Worksheet Functions | |||
I Need VBA Assistance for global variable question | Excel Discussion (Misc queries) |