How to combine values from 2 columns

LINUS_MAASTOK

New Member
Joined
Oct 25, 2019
Messages
11
I everyone!
i have a problem, I want to create a single column from the combination of 2 others from diferent tables...
these columns have a null value or a numerical value, like this:

HTML:
COLUMN_TABLE1--COLUMN_TABLE2 ----- WANTED COLUMN_FROM_ANY_TABLE
(null)---------------(null)-----------------------(null)
(null)---------------8832-----------------------8832
2131----------------(null)----------------------2131
(null)----------------(null)---------------------(null)
3324-----------------3324---------------------3324
2232-----------------(null)---------------------2232

BTW, IM working on Power BI. Also, excuse me for my bad english uwu
 

Some videos you may like

Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).

Gerald Higgins

Well-known Member
Joined
Mar 26, 2007
Messages
9,115
Is it POSSIBLE that you could have an entry like this ?

COLUMN_TABLE1--COLUMN_TABLE2
2131-------------8832

And if the answer is "YES", how do you want to handle it ?
 

sandy666

Well-known Member
Joined
Oct 24, 2015
Messages
6,698
maybe
Table.AddIndexColumn(Table.RemoveColumns(Source,{"COLUMN_TABLE1"}), "Index", 1, 1)

Table.AddIndexColumn(Table.RemoveColumns(Source,{"COLUMN_TABLE2"}), "Index", 1, 1)

merge by Index
then double IF
 

billszysz

Active Member
Joined
Feb 26, 2014
Messages
355
Office Version
  1. 365
Assuming that your data is in Table1 and Table2

Code:
let
    Source = Table.FromColumns({List.Transform(List.Zip({Excel.CurrentWorkbook(){[Name="Tabela1"]}[Content][Column1], Excel.CurrentWorkbook(){[Name="Tabela2"]}[Content][Column1]}), each List.Max(_))})
in
    Source
 
Last edited:

Watch MrExcel Video

Forum statistics

Threads
1,108,729
Messages
5,524,488
Members
409,584
Latest member
RedHelp

This Week's Hot Topics

Top