Custom export with multiple rows for each row in original spreadsh
 

Hi,

I'm looking to create an export file that has multiple rows based in part on
whats in each rows of the original.

For example:

- Original file:
, data, blah, bleh, blech
, data, blah, bleh, blech
, data, blah, bleh, blech

- What I'm after:
, some new hardcoded value, bleck, 33, TRUE, some other val,
etc.
, some new hardcoded value, bleck, 49, FALSE, some other val,
etc.
, some new hardcoded value, bleck, 33, TRUE, some other val,
etc.
, some new hardcoded value, bleck, 49, FALSE, some other val,
etc.
, some new hardcoded value, bleck, 33, TRUE, some other val,
etc.
, some new hardcoded value, bleck, 49, FALSE, some other val,
etc.

Couldn't find a way to specify export formats like this, but maybe I missed
it? Needs to be done in VB or something?

Thanks in advance for any pointers?

:)Ben