Macro for re-arranging data from a csv-file

Hi there,

I was wondering if anyone can help me with the following. I have an csv file with invoice information information that should be shown in a different order. The csv-file has three types of rows:
- The first row contains the header information (K)
- The following rows contain the item information (P).
-The last row has the total amount information (S), which I do not need

This csv-file needs to be created into an XML file; I already have a vbscript for this. The problem is that in order to be able to run this script the data should be in a certain order. The format being that one row contains the header information and the item information instead of two separate rows. If the invoice contains more than one item, an additional row is added, including the header information. Thus:
- The first 18 fields (row1-Type K) of the csv-fille contains the header information. These should be copied to the first row of the xml-conversion sheet.
- The following 14 fields (row2 - type P) of the csv-file contains the item information. These should be copied after the first 18 fields
- If there are more items, then the first two steps should be repeated (!)
- The following 7 fields (after type P -type S) should be ignored.

I have attached an Excel file with how an example of how it should work.

Could anyone help?

Hi JBeaucaire,

-csv-file: Indeed, row one is not in the actual csv-file, i added that manually
- Desired-output: Yes, row 1 and 2 are merely for explanatory purposes