Transpose Column

Question

I don't understand exactly what I'm missing as this seems easy enough.

I'm trying to make the Zone values into their own columns and have the Counts under that..

I'm using the Transpose Tool but every combo isn't giving me the results I need.

Current Data

CountsZoneMDT 25Zone1

2023-07-31 01:00:00 39Zone22023-07-31 02:00:00 45Zone22023-07-31 03:00:00 564Zone12023-07-31 04:00:00 65Zone22023-07-31 05:00:00 85Zone12023-07-31 06:00:00 65Zone22023-07-31 07:00:00

Goal

Zone1Zone2MDT250

2023-07-31 01:00:000392023-07-31 02:00:000452023-07-31 03:00:0056402023-07-31 04:00:000652023-07-31 05:00:008502023-07-31 06:00:000652023-07-31 07:00:00

caltang · Answer

Or you can try something like this:

Forctackett.yxmd

Qiu · Answer

@binu_acs

I rarely use the Imputation tool and always tends to use the Cleansing tool

Thanks for showing a good use case of the Imputation tool. 😁

Jeff_Neklason · Answer

I always feel like the Imputation tool is under valued. This is a excellent simple use case.