I want to display label (or name) for second row in a table so users know about what that row contains, please see image.

Please note: On left there is another grid, thus adding name/label for the row on left isn't possible.

enter image description here

A solution, I think of is to add a legend along side table name text with background similar to the row (similar to colored legends for charts). Although, not sure if that will help.

enter image description here

Please suggest or provide feedback to make it better. Thank you so much!

  • Hello NavenS. I'm trying to figure out how your data is grouped. What do you mean by "on the left there is another grid"? Is this data related to your data for the table you're struggling with? Why does it need to be attached to the table you're asking about? Can you provide more information about how your data is organized and related so we can get a better idea of how it should be displayed? Also, regarding the cells labeled "col", are those column headers? Why do they take up two columns while the cells below merge into one column? – maxathousand Sep 25 '18 at 14:36
  • @Navens, it looks like the last column (Week 13) is cut off. Does that mean the whole table is in a horizontally scrolling pane? – Ken Mohnkern Sep 25 '18 at 15:12
  • Hi @maxathousand, apologies for not for explaining clearly. I have updated the question. Both Left table and Week table are related, by means of some data. The Col name is column headings for Left table. The week number forms column headings for week table. The second row of week table has editable inputs. Now this specific row must be labeled somehow for user to know what data it holds. Any inputs on how it can be done. We can add placeholder text, but these can be empty cells sometimes. – NavenS Sep 25 '18 at 15:15
  • @KenMohnkern, yes the tables are in horizontally scrolling panes – NavenS Sep 25 '18 at 15:25
  • @NavenS - Does each of your text fields need its own label in its table cell? Or just one label for the whole row? If the latter, then why not just add a column for the row labels? More columns will be outside of view, but the scrollable pane will take care of that. – Ken Mohnkern Sep 25 '18 at 15:42

I'm having trouble understanding your question completely, but would something like this work? enter image description here

Alternatively, you can just create a new sheet

  • thanks for answer, but I can't have row names on left per the image you added. I need to somehow add an identifier (or name) for the row immediately follows the column heading row of Week table. – NavenS Sep 25 '18 at 15:45
  • Can you move the second table into a new sheet? Some context and constraints would really help in providing a better answer. – mrchaarlie Sep 25 '18 at 15:50
  • @NavenS please post and share you solution, and then accept it as the right answer then :) – mrchaarlie Sep 27 '18 at 14:54
  • For now I have added word "Factor" inside empty cells and text boxes (as placeholder), it looks repeated but does the job of conveying the type of content for the row. – NavenS Sep 28 '18 at 15:41

Take a look at how Excel or google sheets handle relational data.

screenshot of excel

When the field "tomorrow" is selected, Excel marks the referenced column. You can also click on another id to change the referenced column.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.