Forum Discussion
Solved
Sort rows in smallest to largest but keep the blank rows in place
Hi, Is it possible to sort a column from smallest to largest but keeping every other row which is a blank grey filled line in place? Currently when I sort it will sort the data but removed the gap...
An alternative could be Power Query. In the attached file you can add data to the blue dynamic table. Then you can click in any cell of the green table and right-click with the mouse and select refresh to update the green result table.
https://b23.tv/iyCUEJk
How about HTML output like above?
cli_add_css~tr:nth-child(even)
{
background:grey;
};
create temp table aa as
select * from sort_and_add_even_row_grey where F_A not like '' order by F_A;
select rowid old_rowid,* from aa union all
select rowid,'' from aa order by old_rowid;
How about HTML output like above?
cli_add_css~tr:nth-child(even)
{
background:grey;
};
create temp table aa as
select * from sort_and_add_even_row_grey where F_A not like '' order by F_A;
select rowid old_rowid,* from aa union all
select rowid,'' from aa order by old_rowid;