Format table with variable number of entries

[ccarvalho]

Hi everyone,

I'm trying to get a file formated automatically. This file is extracted from another program every week or so.
In the image below, you can see an example of what I want to achieve. At the top, you see how the data is initially formated, and below how I want it to be.
I've created a macro but the problem is that the macro only works for files with the same number of entries. This table as a variable number of entries: 1 week it has 10 rows, the other 15, the next 8...you get the idea

How can I format the file for a variable number of entries?

Thank you,
ccarvalho

 

[Kamolga]

Hi everyone,

I'm trying to get a file formated automatically. This file is extracted from another program every week or so.
In the image below, you can see an example of what I want to achieve. At the top, you see how the data is initially formated, and below how I want it to be.
I've created a macro but the problem is that the macro only works for files with the same number of entries. This table as a variable number of entries: 1 week it has 10 rows, the other 15, the next 8...you get the idea

How can I format the file for a variable number of entries?

Thank you,
ccarvalho

Hi we can't see the image (only a cross in a small box). I believe you have to save it on some website and share a url instead. Most of all, can you share the macro?