It seems you deleted your reply, anyhow, you can swap the Type tag, replace '1H' with '1D' and '2D' with '1H', then, at the user interface you should change the conditions, checking for '1D' instead of '1H'
=if(Type = '1D', [Detail_Column_Name], ' ')
// for the LOCATION, ITEM and QTY columns
=If(Type = '1D', ' ', [Header_Column_Name])
// for the NO and COMMENTS columns
I tried different visualizations, like Straight Table; Pivot Table and P&L Pivot but the standard Table does the job.
Do You think my proposed solution resolve your problem?
Arnaldo Sandoval A journey of a thousand miles begins with a single step.
It's half resolved. But is it possible to bring the location and Item name against the no and comments column? Because when I make a selection for location or Item, the 'NO' and 'COMMENTS' field is not displayed.