
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Vertical data to horizontal format (Transpose of data)
Hi All,
I have data in the spreadsheet, 1st column should be considered as a dimension. Alongside's columns data should belong to the particular dimension.
Given Input:
Fileds | data | data1 |
name | abc | bcd |
lastname | a | b |
DOB | 10-09-1993 | 16-06-1996 |
Designation | Manager | developer |
Desired Output:
name | lastname | DOB | Designation |
abc | a | 10-09-1993 | Manager |
bcd | b | 16-06-1996 | developer |
Thanks in advance

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
from
Given Input in excel for example
Fileds | data | data1 |
name | abc | bcd |
lastname | a | b |
DOB | 10-09-1993 | 16-06-1996 |
Designation | Manager | developer |
then :
output :
Taoufiq ZARRA
"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "
(you can mark up to 3 "solutions") 😉

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
Require the solution for Qliksense.
Thank you.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
juste try to copy and paste the code and define the path to the data.
attached the Qliksense version
Taoufiq ZARRA
"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "
(you can mark up to 3 "solutions") 😉


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
Maybe you can use crosstable.
crosstable (attribute field name, data field name [ , n ] ) ( loadstatement | selectstatement )
i.e
Crosstable (Month, Sales) LOAD * from ex1.csv;

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
Thanks for the solution.
If we are fetching the data from the source system(SQL) how it is possible.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
When you're configuring data in a Microsoft Excel worksheet, you may realize that the information you entered in rows makes better sense in columns or vice versa.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Looks like the attached solution works only when the source is excel, is there any alternative solution for this issue?


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
First extract the data to create your aux table, after apply Crosstable on it, I think that will be the easier way
