data extraction from excel file

Wow, that's an eccentric structure. There are ways and means, but honestly the easiest by far would be to add named ranges in Excel - is that possible in this instance? If so, you can just read them in as separate tables using the same FME reader.

Hi @kat, I agree that using named ranges is an easy way, but if named range setting is not an option, I would use a global variable to split the source table into sub tables.

1. Excel Reader: Read the spreadsheet using the column names (A, B, C, ...) as attribute names.
2. TestFilter: Routes the feature to "StartSubTable" port if the "A" value starts with "New", otherwise to "Contents" port if the "A" has a value. Discard others.
3. VariableSetter: Save the "A" value ("New Units", "New Cells", etc.) into a global variable.
4. VariableRetriever: Retrieve the global variable and save it into a new attribute. e.g. "_subtable".
5. TestFilter_2: Depending on the "_subtable" value, separate the feature flow into "New Units", "New Cells", and others. Discard others.

@takashi Thank you very much for the solution. It is working great. I've added an attribute creator before the variable retriever otherwise the 'new units' attribute value overwrites the attribute value for column A of the units (aa, bb, etc.). My next question is how can I delete the first row (it's row no 5 on my attached image) of the output for New Units TestFilter and use its values as the attribute name for the subsequent rows instead (for row no 6 - 9 on my attached image)? Thanks again.