Reputation
611
Top tag
Next privilege 1,000 Rep.
See votes, expandable usercard
Badges
4 18 34
Impact
~174k people reached

  • 0 posts edited
  • 1 helpful flag
  • 37 votes cast
Jan
8
comment How can I determine which SQL db my Access app is pointing to?
Because it's not programming. How is determining which db I am pointing at programming? What do you mean "what language". English, do you speak it?
Jan
8
asked How can I determine which SQL db my Access app is pointing to?
Jan
7
asked Can resize but cannot reorder toolbars on taskbar in Windows 7
Dec
23
comment excel:how to convert name-value list of repeating record structure to table/crosstab?
This does answer the question but I now realise that one of the fields is multiline and only has the identifier on the first row which I will have to try and catch. I will post back if and when I figure out the solution (not handling this is resulting in lines 2 to n of said field being dumped)
Dec
23
accepted excel:how to convert name-value list of repeating record structure to table/crosstab?
Dec
23
comment excel:how to convert name-value list of repeating record structure to table/crosstab?
It works! But some extra gotchas were to be found in the form of odd hidden characters. Once removed and the script amended (using excel) to create the other 196 odd columns it ran fine. Thanks
Dec
22
comment excel:how to convert name-value list of repeating record structure to table/crosstab?
It's looking increasingly like that, replete with 200 branch Case statement :-/
Dec
22
comment excel:how to convert name-value list of repeating record structure to table/crosstab?
Yes which means the list to table thing in MSWord won't work either
Dec
22
revised excel:how to convert name-value list of repeating record structure to table/crosstab?
added 253 characters in body
Dec
22
comment excel:how to convert name-value list of repeating record structure to table/crosstab?
The field names are in the same order but as I have now realised after trying to solve this with OFFSET, some of the records do not contain all fields and there are about 200 fields. I will edit the Q to reflect this
Dec
22
comment How do I convert list to table in Excel 2003
no because pivot tables aggregate data and this is not what is being asked for
Dec
22
asked excel:how to convert name-value list of repeating record structure to table/crosstab?
Dec
21
comment How do I convert list to table in Excel 2003
Pivot tables aggregate data, this is not what is being asked for. The question actually wants a crosstab from the list and not a pivot table
Dec
15
awarded  Notable Question
Dec
9
accepted Excel: Copy all cell values from an entire sheet to a new sheet, sort and deduplicate into a single list of unique values
Dec
9
asked Excel: Copy all cell values from an entire sheet to a new sheet, sort and deduplicate into a single list of unique values
Nov
20
asked How to draw a simple diagram or flowchart in Lotus Notes 8.5?
Nov
19
awarded  Famous Question
Nov
16
awarded  Popular Question
Nov
11
awarded  Popular Question