Custom export with multiple rows for each row in original spreadsh

P

pfwebadmin

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:
[email protected], data, blah, bleh, blech
[email protected], data, blah, bleh, blech
[email protected], data, blah, bleh, blech

- What I'm after:
[email protected], some new hardcoded value, bleck, 33, TRUE, some other val,
etc.
[email protected], some new hardcoded value, bleck, 49, FALSE, some other val,
etc.
[email protected], some new hardcoded value, bleck, 33, TRUE, some other val,
etc.
[email protected], some new hardcoded value, bleck, 49, FALSE, some other val,
etc.
[email protected], some new hardcoded value, bleck, 33, TRUE, some other val,
etc.
[email protected], 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
 
Top