Varying number of rows to columns with a start and end condition to group rows

[hmorar]

I have a file with multiple rows. Rows need to be grouped based on a condition of where the grouping starts and ends (in this case, a record starts where columnA = 'BEGIN' and ends where columnA = 'END'). Each group then needs to then be shown as 1 record. See illustrated example below to show you what I mean. Hope someone can help! 🙂

Source file

Desired result

[atcodedog05]

Hi @hmorar 

Can you provide the sample excel file so that we work using it.

[hmorar]

Note - the range of rows varies so take note of the blue shaded cells in the desired result. 

[hmorar]

Sure, here you go.

[Christina_H]

Try this.  You might want to do something different with the Description where it goes onto multiple rows.