# Transpose and Split Data into new Sheet

**URL:** <https://community.glideapps.com/t/transpose-and-split-data-into-new-sheet/73741>\
**Category:** Ask for Help\
**Created:** [May 29, 2024, 5:51pm UTC](https://community.glideapps.com/t/transpose-and-split-data-into-new-sheet/73741 "2024-05-29T17:51:10Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![jmueland](https://avatars.discourse-cdn.com/v4/letter/j/3e96dc/32.png) [@jmueland](https://community.glideapps.com/u/jmueland)\
**Post date:** [May 29, 2024, 5:51pm UTC](https://community.glideapps.com/t/transpose-and-split-data-into-new-sheet/73741/1 "2024-05-29T17:51:11Z")

</div>

I am looking to transpose and split data into a new table in Glide. However, I am having trouble on what the best way to do so would be. Attached below is my current sheet.

 ![Screenshot 2024-05-29 at 1.48.26 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/e/4e745a8a3c9be0ff7a343a4221f5cba4ce3e5623.png)

I was able to do it in a google sheets, and the formula was =transpose(split(Sheet1B2, “,”).

Thank you.

---

<div class="post-metadata">

**Author:** ![Himaladin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/himaladin/32/71023_2.png) [@Himaladin](https://community.glideapps.com/u/Himaladin)\
**Post date:** [May 29, 2024, 6:58pm UTC](https://community.glideapps.com/t/transpose-and-split-data-into-new-sheet/73741/2 "2024-05-29T18:58:24Z")

</div>

First you need to create a row number (see link below). To transpose you need to use a single value column with the configuration: get from start, and the row follows your row index number of the array column you want to transpose.

> [@How do I create an auto-incrementing row number with Glide Tables?](https://community.glideapps.com/t/how-do-i-create-an-auto-incrementing-row-number-with-glide-tables/39572):
>
> This is a question that comes up a lot, so creating this topic to use as a reference. Typically, there are two distinct use cases when it comes to auto-incrementing row numbers. Use Case 1: – We need to generate a Part Number, or an Order Number, or an Employee ID. Once the number is generated, it should never change, even if rows are deleted. – The general approach for this use case is to maintain a static counter, use it to craft a suitably formatted ID, and increment it by one every time…

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\
**Post date:** [June 5, 2024, 11:12pm UTC](https://community.glideapps.com/t/transpose-and-split-data-into-new-sheet/73741/4 "2024-06-05T23:12:29Z")

</div>

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.