how to combine multiple columns in to single column

+1 vote

i have one table, in table columns contains Master,claimid,billed,paid,servicecode,reasoncodeA1,AmountA1,quanityA1,,...etc we have 9 reasoncoden,Amountn,Quantityn coumns data available. see below columns

Master,Claimid,billed,Paid,servicecode,reasoncodeA1,AmountA1,QuantityA1,ReasoncodeA2,AmountA2,QuantityA2,ReasoncodeA3,AmountA3,QuantityA3,ReasoncodeB1,AmountB1,QuantityB1,ReasoncodeB2,AmountB2,QuantityB2,ReasoncodeB3,AmountB3,QuantityB3,ReasoncodeC1,AmountC1,QuantityC1,ReasoncodeC2,AmountC2,QuantityC2,ReasoncodeC3,AmountC3,QuantityC3.

123,10160623,400,200,Hv:2309,45,100,2,125,120,3,null,-120,4,22,10,1,125,400,20,null,null,null,2,null,1,45,100,2,16,1000,4

234,10160645,500,600,sv:28902,16,100,2,null,120,3,2,-120,4,125,10,1,45,400,20,46,200,null,16,null,1,167,100,2,35,1000,4------50 rows

example_output: Reasoncode by Claimidcount

we need Reasoncodes,Claimid

Null ,   10160623,10160645          

45 ,10160623 

125,10160623,10160645

22,10160623

2 ,10160623,10160645

16,10160645,10160623

167,10160645

 35 ,10160645 

46,10160645           

in power bi how to combine multiple columns in to single column, we do unpivot ..etc.

can you please correct answer.

Jul 17, 2019 in Power BI by Power BI
215 views
Multiple claim-id in 1 column?? Unpivoting is the better option.
it is base on reasons wise claimid.

1 answer to this question.

+1 vote
1. Select Edit Queries

2.Select which column you want to merge or combine

3. Click on   Merge Columns options in Add column Tab
answered Aug 6, 2019 by anonymous

Related Questions In Power BI

+1 vote
1 answer

How to filter on multiple columns in single table

I used dummy data to show how to ...READ MORE

answered Jul 10, 2019 in Power BI by sindhu
4,204 views
0 votes
4 answers

How to combine multiple tables in power BI?

Click Advanced Editor and check if step #"Appended ...READ MORE

answered Dec 16, 2020 in Power BI by Roshni
• 10,440 points
19,904 views
0 votes
1 answer

How to combine your data or tables in Power BI?

Power BI includes Query Editor which is ...READ MORE

answered Feb 27, 2019 in Power BI by Phalguni
• 1,020 points
961 views
0 votes
1 answer

How to add multiple reference lines on a bar/ column graph?

Hi, Follow below steps: 1. Add a bar/ column ...READ MORE

answered Mar 26, 2019 in Power BI by Cherukuri
• 32,930 points
4,366 views
0 votes
1 answer

How to rename a column using DAX in Power BI?

Hi Ramya, I found these two function that ...READ MORE

answered Aug 21, 2019 in Power BI by anonymous
• 32,930 points
8,990 views
0 votes
0 answers

How to count of category values in a column?

How to count of category values in ...READ MORE

Oct 30, 2019 in Power BI by ch
• 3,450 points
201 views
0 votes
1 answer

Displaying Table Schema using Power BI with Azure IoT Hub

Answering your first question, Event Hubs are ...READ MORE

answered Aug 1, 2018 in IoT (Internet of Things) by nirvana
• 3,150 points
332 views
+1 vote
1 answer

Unable to install connector for Power Bi and PostgreSQL

I think the problem is not at ...READ MORE

answered Aug 21, 2018 in Power BI by nirvana
• 3,150 points
1,472 views
+2 votes
2 answers

Migrate power bi collection to power bi embedded

I agree with Kalgi, this method is ...READ MORE

answered Oct 11, 2018 in Power BI by Hannah
• 18,550 points
447 views
+1 vote
1 answer

Connect power bi desktop to dataset and create custom reports

Yes using Power BI REST API to ...READ MORE

answered Sep 18, 2018 in Power BI by Kalgi
• 52,310 points
497 views