Data Arrangement Excel and SQL Server -

Data Arrangement Excel and SQL Server -

hi need arrange below info based on column 1 value in order without sorting after first 2 rows need row 12 comes in group. kindly suggest excel macro or sql script.

col1 col2 col3 col4 col5 col6 col7 v(e) dos x y y binders, , mixtures thereof, follows v(e)(1) dos x y y ammo (azidomethylmethyloxetane , polymers) (cas 90683–29–7) dos x y y firearms, close assault weapons , combat shotguns i(a) dos x y y non-automatic , semi-automatic firearms caliber .50 inclusive (12.7 mm) i(b) dos x y y automatic firearms .50 caliber inclusive (12.7 mm) 2b001.e doc at1,ns2 y y machine tools removing metals, ceramics or "composites", having of following: 2b001.e.1 doc at1,ns2 y y removing material means of of following: 2b001 doc at1,np1,ns2 y y machine tools , combination thereof, removing (or cutting) metals, ceramics or "composites," which, according manufacturer's technical specifications, can equipped electronic devices "numerical control", follows (see list of items controlled). 2b001.a doc at1,np1,ns2 y y machine tools turning having of following: i(c) dos x y y firearms or other weapons (e.g. insurgency-counterinsurgency, close assault weapons systems) having special armed forces application regardless of caliber v(e)(2) dos x y y bamo-3-3-(bis(azidomethyl)oxetane , polymers) (cas 17607–20–4) (see paragraph (g)(1)of category) 2b001.a.1 doc at1,np1,ns2 y y positioning accuracy according iso 230/2 (2006) "all compensations available" equal or less (better) 4.5 µm along 1 or more linear axis 2b001.a.2 doc at1,np1,ns2 y y 2 or more axes can becoordinated simultaneously "contouring control" 2b001.e.1.a doc at1,ns2 y y water or other liquid jets, including employing abrasive additives 2b001.e.1.b doc at1,ns2 y y electronic beam 2b001.e.1.c doc at1,ns2 y y "laser" beam

excel -> info ribbon -> text columns. select "next", "tab" radio , "finish" select info columns data ribbon -> "filter" select header in column 1. "sort"

sql excel