I have 2 tables
Table 1
Column A, Column B
Table 2
Column B, Column C
How can I get a table to display the following in one row.
Column A, Column B, Column C (Where Column B is the same value for both tables - KEY). The order doesn't matter eg, it could be column B, A, C
I've tried pivot tables, but the data isn't displayed across in a row. Tried merging and consolidating, but I must be missing a step.
Can someone step me thru the process? All the values are TEXT values but sometimes Column B does not have any values (blanks) for some of the rows of data.
Table 1
Column A, Column B
Table 2
Column B, Column C
How can I get a table to display the following in one row.
Column A, Column B, Column C (Where Column B is the same value for both tables - KEY). The order doesn't matter eg, it could be column B, A, C
I've tried pivot tables, but the data isn't displayed across in a row. Tried merging and consolidating, but I must be missing a step.
Can someone step me thru the process? All the values are TEXT values but sometimes Column B does not have any values (blanks) for some of the rows of data.