Forum Discussion
Change data set structure, unsure how to transform this
It could be done with Power Query
please see in attached file.
If with formulae it depends on which Excel platform/version you are and how big the source data.
It could be done with Power Query
please see in attached file.
If with formulae it depends on which Excel platform/version you are and how big the source data.
SergeiBaklan thanks for the suggestion! Your sample file was helpful. While I was in Power Query, I noticed the Unpivot Columns transformation feature and it worked as well. I selected the 3 date columns to Unpivot and it transforms the table into desired tabular data. 2 solution options if anyone else has this use case. Thanks.
Oops, I misunderstood how source data is organized. If from first table to second
yes, that's two-step Power Query script
let Source = Excel.CurrentWorkbook(){[Name="data"]}[Content] in Table.UnpivotOtherColumns(Source, {"Project"}, "Gate", "Date")
