January 19, 2019
I have a table of 5 columns, ticket, log_user, log_time,log_user2,Log_time 2(start attached). I want to have one table of three columns: ticket, log_user and log_time.
I created 2 duplicate copies of the above query. I grouped the first by ticket and log_user, and aggregated it by log_time(two attached). I grouped the second by ticket and log_user2, and aggregated it by log_time2(three attached).
I attempted to append both tables and instead of getting 3 columns, I got 4(finish attached).
How do I append the two grouped tables so I get all users in one column, and don't get the fourth column?
[Image Can Not Be Found]
Xtreme Pivot Tables
Excel for Decision Making
Excel for Finance
Excel Analysis Toolpak
Excel Customer Service
November 8, 2013