-1

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?

Improve this question

1 Answer 1

Reset to default
1

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...

Improve this answer
1
  • 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
    Commented Jun 22, 2018 at 5:53

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