473,246 Members | 1,480 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,246 software developers and data experts.

transform like excel possible?

how do i translate this table:

tag stunden projekt_nr
3 7,75 7192500
4 7,75 7192500
5 7,75 2118310
6 7,75 2118310
7 3 2118310
7 3 7192500
10 6 2118310
10 2,25 7194400
11 2 2118310
11 5 7192500
11 2,25 7194400
12 1,5 2114011
12 6,75 2118310
13 6,25 2117710
13 2 2118310
14 3 2118308
14 2 2118310
14 2 7192500
17 7,75 2118310
18 2 2117710
18 3,75 2118310
18 2 7192500
19 1,5 2117710
19 7,25 2118310
25 9,25 2118310
26 3 2117710
26 4,5 2118310
26 2,25 7192500
27 4 2117710
27 1,25 2118310
27 3 7192500
28 1 2117710
28 5 2118310

.... in this:
tag Gesamtsumme 2114011 2117710 2118308 2118310 7192500 7194400
3 7,75 7,75
4 7,75 7,75
5 7,75 7,75
6 7,75 7,75
7 6 3 3
10 8,25 6 2,25
11 9,25 2 5 2,25
12 8,25 1,5 6,75
13 8,25 6,25 2
14 7 3 2 2
17 7,75 7,75
18 7,75 2 3,75 2
19 8,75 1,5 7,25
25 9,25 9,25
26 9,75 3 4,5 2,25
27 8,25 4 1,25 3

please help me!

thx
peter
28 6 1 5
Jul 19 '05 #1
0 1342

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

6
by: Sharon | last post by:
Hi! I'm trying to add an export option to my application. I use Javascript DOM to transform XHTML-tables displayed in the browser window to CSV-format (client-side) using a simple XSL. All works...
0
by: glen | last post by:
I used the below code to transform xml to a spreadsheet using a .xsl file. It works great; problem is I want to transform several recordset to xml to multiple worksheets in the workbook. Should I...
5
by: KathyB | last post by:
If someone could just explain this to me...I just don't get it! I have an aspx page where I retrieve several session variables and use xmlDocument to transform xml file with xsl file into an...
8
by: Luther Miller | last post by:
I am using the XML tranform functionality in .NET to transform data in a DataSet into XMLSS using an XSLT file I have created. There are about 100 columns and only about 120 rows in the data...
3
by: b0yce | last post by:
Hi Group, I think I have found a problem with the <xsl:element> when being transformed by the .NET xmlTransform class. When using XmlSpy for development and debugging, the <xsl:number>...
4
by: m.ahrens | last post by:
Hi all I have an xsl file and would like to transform it into an xml file. The same way as if i would open the xsl file in excel and then save as... xml file (Office 2003). is there a way to do...
7
by: Doug Heeren | last post by:
I have the following section of VB.NET code that transforms a simple dataset into an Excel xml workbook. It works fine for < 50 rows or so, but I have about 8,000 rows I need to transform. Is there...
2
by: Wilson Wu | last post by:
hi, how can i use xslt to transform xml data into excel worksheet ? XML file : <?xml version="1.0" encoding="UTF-8"?> <?xml-stylesheet type="text/xsl" href="test5.xsl"?> <dataroot...
1
by: andy | last post by:
Hi I am writing a procedure to load an excel file into an xml file that can be validated before loading it into a database via an api. At the moment I can read the excel file into a dataset...
1
by: chandrasekhar | last post by:
Transform data in excel to SQL Server 2000 How could I insert data stored in Excel into some table in SQL Server 2000? Is it posible? Thanks.
0
by: abbasky | last post by:
### Vandf component communication method one: data sharing ​ Vandf components can achieve data exchange through data sharing, state sharing, events, and other methods. Vandf's data exchange method...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: stefan129 | last post by:
Hey forum members, I'm exploring options for SSL certificates for multiple domains. Has anyone had experience with multi-domain SSL certificates? Any recommendations on reliable providers or specific...
1
by: davi5007 | last post by:
Hi, Basically, I am trying to automate a field named TraceabilityNo into a web page from an access form. I've got the serial held in the variable strSearchString. How can I get this into the...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: Aftab Ahmad | last post by:
So, I have written a code for a cmd called "Send WhatsApp Message" to open and send WhatsApp messaage. The code is given below. Dim IE As Object Set IE =...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: marcoviolo | last post by:
Dear all, I would like to implement on my worksheet an vlookup dynamic , that consider a change of pivot excel via win32com, from an external excel (without open it) and save the new file into a...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.