I am using qgis version 2.18.19.I want to join excel file with the attribute table of a shape file.My attribute table has 1 row and 4 column.Excel file table has 1 column and 8 rows.I have experience in joining excel file which include 8 column and 1 row.

Therefore I feel,If i can convert excel table of 8 rows 1 column in to a table of 8 column and 1 row withing the qgis,There is a chance to achieve my goal.So is this possible in qgis?

closed as unclear what you're asking by Andre Silva, Vince, nmtoken, PolyGeo Jun 17 '18 at 7:34

Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.


According to a previous post Transpose attribute table in QGIS Composer?, this can't be done inside QGIS, but there is a good work around:

  • Save your table as a CSV file,Right-click the file and go to save as
  • in format choose Comma Separated Values (CSV)
  • open it in Excel.
  • use copy, Paste Special ->Transpose, in excel after (or before) you've filtered your data.

the first link provides some Pictures if you struggled...

  • Actually I am new to this site.Some time my question may be very primary question.But your answer really helpful.It helps me to think differently.thank you very much – Shanaka Herath Jun 22 '18 at 5:53

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