Transpose attribute table in QGIS Composer?

Question

I have difficulty in how to rotating attribute table in QGIS Composer. The default is horizontal, it's because data I have too much around 50 tables. So I want to rotated it to horizontal.

Under the map, or maybe there is another way for me to include this all record and print it out?

Answer 1

There is no direct way to rotate/transpose your attribute table in the map composer as far as I know. A workaround to this is:

1. Right-click the file and go to Save as then save your attribute table as CSV. If you don't want to add XY coordinates as additional columns to the CSV file, select Default in GEOMETRY under Layer options.

2. Open the CSV file in Excel
3. Then copy the columns
4. Paste them on another sheet using paste special, and select Transpose
5. Save it again as a CSV file

Then drag and drop the new CSV file into QGIS. In the composer add the transposed attribute at the bottom of your map.

Answer 2

@ahmadhanb's answer is a good workaround but here is another way to deal with long tables.

Although there is no way to transpose a table in the composer, you can split your table into multiple frames. Now depending on the case, this could be more or less elegant, but this is how the result looks like:

Here's how to do it:

1. Add a table as you would normally do and select its source layer.
2. Scroll down the properties till you get to Frames.
3. Click Add Frame.
4. Align and resize your frames as may be suitable to your map layout.
5. It is also a good idea to turn on Show only features visible within a map. This way you won't have a table with all the layer features on your map!

P.S. It is possible to rotate the table, but unfortunately, the text also rotates and you end up with vertical text, which doesn't look very elegant.

Answer 3

Here is a solution to get a transposed attribute table for one feature at a time in an Atlas. This solution works if creating one map for each feature is acceptable.

First set up you an atlas: Atlas settings - choose your layer as the coverage layer (the atlas will create a map for every feature and zoom on that feature, the next steps explain how to show the attributes of the zoomed-in feature, in column format, on each map).

Before adding a Fixed Table to you map Layout, you might want go to a spreadsheet editor (LibreOffice Calc or Excel): paste your attribute table in transpose (right-click - paste special - transpose) - you only need the column names (transposed to rows). Add a second column with this formula (assuming first element is in cell A1): =CONCAT("attribute('";H14;"')") Copy the two columns:

Back to the map Layout, add a Fixed Table, then paste you data (File - Import content from clipboard). (I modified the X and Y attribute names to show the point coordinates.):

For some reason, the second row is not recognized as an expression; for each row, you will have to manually copy-paste the cell content to the Expression box to the right. Once done for every row, you can close the table:

To see the result don't forget to go click on Atlas Preview! (remember, this is an atlas) I added a second map with an overview:

Protip for the Overview: item properties - overviews - Frame style - change to OutlineSimpleLine and use a negative offset to make the overview square a bit larger and more visible on your map):