How to transform raw data in Pivot table format to row base?

[Pliew]

I have a raw data that comes in a pivot table format (example the raw data below with just data1 and data2) . Wanted to  revert  the pivot table  (refer target format)

1) all date in date

2) all data in column name starts with "data" are to be ingested to a single value" column.

3) all column's name are to be ingested in the "data" column respectively.

Tried using the "Arrange" tool but finds it not productive when I have a large number of column to convert, any idea how to do this more effectively?

The raw data:	Target format:

Thanks

Paul

[ThizViz · Accepted solution]

I believe the Transpose tool is what you're looking for...

[Pliew]

Thank you.