Trying to find a way to remove all of the null column in each of the column, but not delete the other value in column 2
Starting Table:
Table I want to get
Power Query:
= #table({"Column 1", "Column 2"}, {{"439","772"},{"3241",null},{"1552","1143"},{"1308",null},{"3562","3242"},{null,"2494"},{"2043","1527"},{"1749","2162"},{"3472","1646"}})
Starting Table:
Book3 | ||||
---|---|---|---|---|
A | B | |||
1 | Column 1 | Column 2 | ||
2 | 439 | 772 | ||
3 | 3241 | |||
4 | 1552 | 1143 | ||
5 | 1308 | |||
6 | 3562 | 3242 | ||
7 | 2494 | |||
8 | 2043 | 1527 | ||
9 | 1749 | 2162 | ||
10 | 3472 | 1646 | ||
Sheet2 |
Table I want to get
Book3 | ||||
---|---|---|---|---|
A | B | |||
1 | Column 1 | Column 2 | ||
2 | 439 | 772 | ||
3 | 3241 | 1143 | ||
4 | 1552 | 3242 | ||
5 | 1308 | 2494 | ||
6 | 3562 | 1527 | ||
7 | 2043 | 2162 | ||
8 | 1749 | 1646 | ||
9 | 3472 | |||
Sheet3 |