Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
can i wrap rows to form multiple rows per row to fit on 1 sheet? | Excel Discussion (Misc queries) | |||
Insert rows based on specific value | Excel Worksheet Functions | |||
Select rows of data in a worksheet on one criteria in multiple co | Excel Worksheet Functions | |||
Multiple rows of data on a single axis (charting) | Charts and Charting in Excel | |||
Counting rows based on criteria in multiple cells | Excel Discussion (Misc queries) |