Transform

[zezo2021]

Hello friends

I need to transform the attached table to new table

You will see explain in Excel
Source Table
Transform Table

How can I do that using query

Thank you in advance for your help

 

[plog]

Very similar thread going on right now about this:

Transpose From Horizontal to vertical format

hi, i have a problem to transpose from horizontal table to vertical table here is TempTable 04-00-OPU_DetailsID Code RateCategory EqType Desc Spec 01/07/2021 02/07/2021 03/07/2021 04/07/2021 05/07/2021 10 ECT0045 12 T8A Mobile Crane with Operator & signalman 45T 3 2 4 4 4 what should...

www.access-programmers.co.uk

 

[arnelgp]

demo of what you need.

 

[June7]

In Access that would be a UNION query.
SELECT Project, Function, Category, Key, [2020-2040] AS Value, "2020-2040" AS SrceDate FROM table
UNION SELECT Project, Function, Category, Key, [1Q20], "1Q20" FROM table
UNION SELECT Project, Function, Category, Key, [2Q20], "2Q20" FROM table;

If you want to do in Excel Power Query that would be an UNPIVOT https://support.microsoft.com/en-us...during a refresh operation are also unpivoted..

 

[zezo2021]

demo of what you need.

Thank you so much for your help and assistance

I will check the project