Create single table with multiple columns

[harshadrokade]

Thanks for looking into the query.

I have below data

ID

Latest_updated_Date__c

Last_update_Date_1__c

Last_update_Date_2__c

Last_update_Date_3__c

Last_update_Date_4__c

Last_update_Date_5__c

Latest_Stage__c

Last_update_stage_1__c

Last_update_stage_2__c

Last_update_stage_3__c

Last_update_stage_4__c

Last_update_stage_5__c

Amt

122333

September 5, 2023

August 20, 2023

August 5, 2023

July 20, 2023

July 5, 2023

A

A

A

A

A

16

122334

September 5, 2023

August 20, 2023

August 5, 2023

July 20, 2023

July 5, 2023

B

A

A

A

A

16

122335

September 5, 2023

August 20, 2023

August 5, 2023

July 20, 2023

July 5, 2023

A

A

A

A

A

13

122336

September 5, 2023

August 20, 2023

August 5, 2023

July 20, 2023

July 5, 2023

A

A

A

A

A

9

122337

September 5, 2023

August 20, 2023

August 5, 2023

July 20, 2023

July 5, 2023

C

A

A

A

A

4

122338

September 5, 2023

August 20, 2023

August 5, 2023

July 20, 2023

July 5, 2023

B

B

B

B

9

122339

September 5, 2023

August 20, 2023

August 5, 2023

July 20, 2023

July 5, 2023

A

A

A

A

A

4

122340

September 5, 2023

August 20, 2023

August 5, 2023

July 20, 2023

July 5, 2023

B

A

A

D

D

15

I have created seperate tables as below with the same.

As the stages are common in all the tables above, How can I create a single table where the Stage column will come only once, There will be multiple date columns with amt as below-

[mickey64 · Accepted solution]

Step 1: I select 2 columns and merge with space.

Step 2: I change column name, "Date Stage 0".

Step 3: I do same steps for other columns.

Step 4: I select "Date Stage 0"-"Date Stage 5" and pivot...

Step 5: I separate a column with space.

Step 6: I change 2 names of columns.

Step 7: I go to Power BI Desktop and make matrix.