[Solved] Split data into different sheets by keyword

[BinuV]

Hi Everyone,

I was trying to split a spreadsheet into two different one as in the attached file here.

What I was looking to do was to print all the values from Sheet X correspond to "A" in Sheet A and Values corresponds to "B" in Sheet B using formula. Discussed the same in the forum earlier, but I was unable to convey actual challenge I was facing correctly.

Attached a sample spreadsheet here regarding the same. I was able direct the values of Corresponding to "A" from Sheet X to Sheet A by formula but failed to execute the same for B. ( Needed to print the values from the beginning of the Sheet B)

If someone could help me in this, that would be a great relief for me.

Edit: Changed subject, was Splitting spreadsheets into different sheets with regard to a specific keyword.  Make your post understandable by others  -- MrProgrammer, forum moderator

[Lupp]

I would prefer the interactive usage of StandardFilter as demonstrated for two result sheets in the example.
Under specific conditions somebody may prefer a solution by formulas based on standard functions. This comes with well-known disadvantages related to scaling and to the needed usage of helpers and array-evaluation.
However, such a solution is also demonstrated (for up to 100 data rows).
A third way would be to write specialized user code. Depending on the circumstances I would possibly prefer this way, but that's an approach for a user knowing how to write and maintain user code.
The announced example:

aoo110131GroupingByOneDataField.ods

(72.76 KiB) Downloaded 124 times

===Editing a few hours later===
BTW: The example showed only adjacent groups. If the groups are actually assured to be adjacent, things are much simpler, of course.

Also: The columns A through D of the sheet ByFormulasSelectableGroup are only showing the relevant rows of original data. They are not used to get the final results.

[BinuV]

Hi Lupp,

Thank you so much for the guidance!