Forum Discussion

Hamdan1234's avatar
Hamdan1234
Icon for Helper III rankHelper III
4 years ago
Solved

Column Combine to one

I had three columns of courses information,two of them merged and now look like this: A1 A2 A3 A4 B1 B2 B3 B4 Now I want to merge this column with another table column bu...
Need Help
  • v-zhangti's avatar
    v-zhangti
    4 years ago

    Hi,@Hamdan1234

    You can try the following steps:

    1. Create two tables, as shown in the figure below.

    2. Select the classroom and online columns in the table，Transform—Unpivot Only Selected Columns

    3. Merge Table and course, and the results are shown in the figure.

     

    4. Select display only user, and the result is as shown in the figure.

    If the method I provided above can't solve your problem, what's your expected result? Could you please provide more details for it?

    Best Regards,

    Charlotte Zhang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-zhangti's avatar
v-zhangti
Icon for Community Support rankCommunity Support
4 years ago

Hi,@Hamdan1234

You can try the following steps:

1. Create two tables, as shown in the figure below.

2. Select the classroom and online columns in the table，Transform—Unpivot Only Selected Columns

3. Merge Table and course, and the results are shown in the figure.

 

4. Select display only user, and the result is as shown in the figure.

If the method I provided above can't solve your problem, what's your expected result? Could you please provide more details for it?

Best Regards,

Charlotte Zhang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.