# Unstack dataframe with combine by the same date

**URL:** <https://discourse.julialang.org/t/unstack-dataframe-with-combine-by-the-same-date/106614>\
**Category:** General Usage\
**Tags:** question\
**Created:** [November 23, 2023, 8:15am UTC](https://discourse.julialang.org/t/unstack-dataframe-with-combine-by-the-same-date/106614 "2023-11-23T08:15:26Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Tatiana\_P](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/tatiana_p/32/45801_2.png) [@Tatiana\_P](https://discourse.julialang.org/u/Tatiana_P)\
**Post date:** [November 23, 2023, 8:15am UTC](https://discourse.julialang.org/t/unstack-dataframe-with-combine-by-the-same-date/106614/1 "2023-11-23T08:15:26Z")

</div>

What is the simplest way to unstack the following dataframe

df = DataFrame(date=[Date(2018,1,1), Date(2018,1,1), Date(2018,1,1), Date(2018,1,2), Date(2018,1,2), Date(2018,1,2)], B=[“T1”, “T2”, “T3”, “T1”, “T2”, “T3”], value=1:6)

![image](https://global.discourse-cdn.com/julialang/original/3X/c/e/cefbd9d28ad2e790eda8a5d7132a59f11fbfaa08.png)

and get such dataframe

![image](https://global.discourse-cdn.com/julialang/original/3X/3/6/36d45d98f9d5d3ca8a289a149eab44dad1a70af7.png)

Thank you for answering.

---

<div class="post-metadata">

**Author:** ![Rudi79](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/rudi79/32/3884_2.png) [@Rudi79](https://discourse.julialang.org/u/Rudi79)\
**Post date:** [November 23, 2023, 8:56am UTC](https://discourse.julialang.org/t/unstack-dataframe-with-combine-by-the-same-date/106614/2 "2023-11-23T08:56:17Z")

</div>

> [@Tatiana\_P](#):
>
> df = DataFrame(date=[Date(2018,1,1), Date(2018,1,1), Date(2018,1,1), Date(2018,1,2), Date(2018,1,2), Date(2018,1,2)], B=[“T1”, “T2”, “T3”, “T1”, “T2”, “T3”], value=1:6)

```julia
unstack(df, :date, :B, :value)

```

should do the trick.