Each cell content report

From this example sheet:

image description

Once upon a time, I just thought of it. Lotus123 Spreadsheet could report :

A 1 Rice

A 2 Iron

B 1 Vegetable

B 2 Copper

C 1 Vitamin

C 2 Aluminum

Can Calc do like that ?

No, I do not know this form of expression.

You can print it out with the headings of the columns and rows.

Choose Format>Page from the menu. In the “Page Style: Default” dialog box, select the “Sheet” tab, set checkmark to “Print” - “Column and Row headers”.

This is the result:

image description

If my answer has solved your problem, please click on the checkmark ✓ in the circle image description to the left of the answer and click on the arrow ^ for upvote. This will tell the community that the question has been answered correctly.

With me Windows 10 Home; Version 1903; 64-Bit | LibreOffice, Version: (x64).