Customizing order of joined cell header values when cell value isn't blank in Google Sheets (-CodePudding

Home > Back-end > Customizing order of joined cell header values when cell value isn't blank in Google Sheets (

Customizing order of joined cell header values when cell value isn't blank in Google Sheets (

Time：06-25

How can I modify the equation in this

However, it would be preferable if the order could be arranged based on providing an order in the header value like the following display where empty cells (where ISBLANK=TRUE) are not displayed (2 & 3). Also, the header/value pair for "History" are not displayed since a _History is provided in the column header without a number.