0

How to transpose a table in Klipfolio?

Iana Ishchuk

January 18, 2019 00:56

None

Follow

Hello.

Is it possible to transpose a table in Klipfolio?

Best,

Iana 

• Facebook
• Twitter
• LinkedIn

7 comments

• 0
  
  Janice Janczyn January 22, 2019 16:07

  Hi Iana,

  I'm not sure if I understand your question correctly, but if you're asking how to re-orient the data in a tabular datasource such that the rows are treated as columns, the simplest way is to model your datasource and then use the modelled datasource in your klip. Following that approach, each column in your modelled datasource would point to a row in your datasource.

  Thank you,
                Janice

• 0
  
  Iana Ishchuk January 22, 2019 17:19

  Hi Janice,

  Thank you. I would like to read about modelled data sources, but the link doesn't work.

  Iana 

• 0
  
  Janice Janczyn January 22, 2019 18:51

  My apologies, Iana!  Here is the correct link.

  Janice

• 0
  
  Iana Ishchuk January 22, 2019 22:48

  Thank you

• 0
  
  Chandrasen Rajashekar March 29, 2019 12:04

  @Iana Ishchuk did you manage to do so using the data modelling option in Klipfolio?

• 0
  
  Iana Ishchuk March 29, 2019 19:48

  Hi Chandrasen Rajashekar, 

  Unfortunately, I didn't get how to re-orient the data in a tabular datasource such that the rows are treated as columns through the data modelling option.

  I use a lot of modelled sources, but still don't understand how I can solve this problem.

   

  Best, 

  Iana Ishchuk

• 0
  
  Meggan King March 29, 2019 20:06

  Hi There,

  It might be easiest to look at your issue via a support ticket (support@klipfolio.com) but at a high level, you can select data by columns A:A or by rows 1:1, 2:2, etc. 

   

  If you want your top row to be the data in your formula, then you'd do 1:1 and if you want to skip the first cell, you'd do SLICE(1:1). 

   

  Please send in a ticket, if you'd like more specific help!

  Thanks

  Meggan