Forum Discussion

dinosainsburys's avatar
dinosainsburys
Icon for Helper I rankHelper I
2 years ago

How do I get columns to append each other?

I get data via an API which is then presented in Power BI like this.   Computer RESULTS.DATE.0 RESULTS.DATE.1 RESULTS.VALUE.0 RESULTS.VALUE.1 RESULTS.VALUE.3 COMP-4573 12/12/2023 13/12...
Need Help
Show and Tell
Tutorial Requests
dinosainsburys's avatar
dinosainsburys
Icon for Helper I rankHelper I
2 years ago

So using this table as an example:

 

 

ComputerRESULTS.DATE.0RESULTS.DATE.1RESULTS.DATE.2RESULTS.DATE.3RESULTS.DATE3
COMP-457312/12/202313/12/202314/12/202315/12/202316/12/2023
COMP-457812/12/202313/12/2023 14/12/202315/12/2023 16/12/2023
xxxxxxxxxxxxxxxxxxxxxxxxx

 

I want it to look like this:

 

 

ComputerRESULTS.DATE.COMBINEDRESULTS.DATE.1RESULTS.DATE.2RESULTS.DATE.3RESULTS.DATE3
COMP-457312/12/2023    
COMP-457813/12/2023    
xxxx14/12/2023    
 15/12/2023    
 16/12/2023    

 

So essentially combining the columns into one.