Forum Discussion
Power BI Match Column Headers and Fill Rows with single Value from a Different Table?
Table A has thousands of rows of data. Table B has data structured as such: A B 2/28/2019 28 3/31/2019 59 4/30/2019 89 5/31/2019 120 ...etc for 5 years Essentially w...
v-lili6-msftThanks for the reply. I sort have already tried your suggestion. I tried to unpivot and then merge the two tables. The issue is that there are no matching rows between Table A and Table B so nothing returns. If I make the join to include all rows from each table that does not really help either as the thousands of rows from Table A won't have any values in the new merged column since there are no matching rows.
I really want to just dump the value of a column in Table B into every row in Table A.
v-lili6-msft
Community Support
Community Supporthi, Anonymous
Please share some sample data(or virtual data) from table A and expected output.
and if you could try Transpose function in power query
Best Regards,
Lin