Rearrange data output!

[cpmsimoes]

Hello everyone,

I have an excel macro to convert a tabular data into a flatfile (thanks for ExcelForum) and it does my needs, however I would like to improve it and get the result more compacted, for example having revenue and COS ins the same line for similar products/customers regions etc

I attached a file with the macro result and the expected result.

Thanks for your help
Regards

[Richard Buttrey]

Can I suggest that since this is an extension to your earlier thread that you post the request in that thread.

[cpmsimoes]

Ok, I'll add it in the earlier thread. Can you delete this one?
Thank you.

[Richard Buttrey]

Hi,

We don't delete threads as a general rule but i will close it.

[Richard Buttrey]

Thread Closed