Answers.Body: <p>You could script it as an excel macro but yes in 5.50 there will be something similar called Segmentation in search kit.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2022-05-23T07:51:44.787Z
Answers.Text: Thanks for the answer :-0 I have no idea what the first bit means - my excel skills are good but not that good. :-) . I am leaving my job soon so wont be in a position to do it, but thanks for the segmentation tip
Answers.UserDisplayName: Russell
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2022-05-20T15:36:35.610Z
Answers.LastActivityDate: 2022-05-20T15:36:35.610Z
Answers.UserDisplayName: Demerit
Body: <p>Ive used search kit and created a list of service user demographics, there are 7 columns, age, gender, ethnicity etc.</p>
  <p>I then download the csv, copy and paste to excel and then have to create pivot for the different headings.</p>
  <p>Is there any way that this can be done in search kit at all?</p>
  
Tags: <searchkit>
Title: Use search kit like a pivot table?
ThreadText: # Use search kit like a pivot table?
  
  (Asked by: username_0 on 2022-05-20)
  
  Ive used search kit and created a list of service user demographics, there are 7 columns, age, gender, ethnicity etc.
  
  I then download the csv, copy and paste to excel and then have to create pivot for the different headings.
  
  Is there any way that this can be done in search kit at all?
  
  **Tags:** searchkit
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2022-05-20. Score: 2
  
  You could script it as an excel macro but yes in 5.50 there will be something similar called Segmentation in search kit.
  
  > **Comments:**
  > **username_0**: Thanks for the answer :-0 I have no idea what the first bit means - my excel skills are good but not that good. :-) . I am leaving my job soon so wont be in a position to do it, but thanks for the segmentation tip  
  
  ---
  
  