View Single Post
  #1   Report Post  
pfwebadmin
 
Posts: n/a
Default 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