0

How to transpose a table in Klipfolio?

Hello.

Is it possible to transpose a table in Klipfolio?

Best,

Iana 

7 comments

  • 0
    Avatar
    Janice Janczyn

    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
    Avatar
    Iana Ishchuk

    Hi Janice,

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

    Iana 

  • 0
    Avatar
    Janice Janczyn

    My apologies, Iana!  Here is the correct link.

    Janice

  • 0
    Avatar
    Iana Ishchuk

    Thank you

  • 0
    Avatar
    Chandrasen Rajashekar

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

  • 0
    Avatar
    Iana Ishchuk

    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
    Avatar
    Meggan King

    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

     

     

Please sign in to leave a comment.