Hi All How to transpose vertical date to horizontal date, Samples are below. From below DateCountryCount01-Jan-24US101-Jan-24Africa101-Jan-24UK101-Jan-24Canada101-Jan-24France102-Jan-24US102-Jan-24Africa102-Jan-24UK102-Jan-24Canada102-Jan-24France103-Jan-24US103-Jan-24Africa103-Jan-24UK103-Jan-24Canada103-Jan-24France1 To below Country01-Jan-2402-Jan-2403-Jan-24US111Africa111UK111Canada111France111

How to transpose vertical date to horizontal date

Hi All

How to transpose vertical date to horizontal date, Samples are below.

From below
Date	Country	Count
01-Jan-24	US	1
01-Jan-24	Africa	1
01-Jan-24	UK	1
01-Jan-24	Canada	1
01-Jan-24	France	1
02-Jan-24	US	1
02-Jan-24	Africa	1
02-Jan-24	UK	1
02-Jan-24	Canada	1
02-Jan-24	France	1
03-Jan-24	US	1
03-Jan-24	Africa	1
03-Jan-24	UK	1
03-Jan-24	Canada	1
03-Jan-24	France	1

To below
Country	01-Jan-24	02-Jan-24	03-Jan-24
US	1	1	1
Africa	1	1	1
UK	1	1	1
Canada	1	1	1
France	1	1	1

Help

Accepted answers

All comments

flying008

Hi, @shahnawaz_khan

FYI.

录制_2024_07_15_16_07_30_862.gif 录制_2024_07_15_16_10_13_928.gif

Raj

@shahnawaz_khan
find the workflow attached

2146.yxmd

shahnawaz_khan

Thanks, that helped allot.

😊

Raj

@shahnawaz_khan
you can mark this done and close thread if solved.

happy to help

LindonB

Use a cross tab tool, configured as below. Either convert your date field to a Date format prior to the cross tab tool using the datetime tool, or (if you want to keep it formatted the same), use a dynamic rename tool after to pivot to replace the underscores (that will replace the dashes. In the below, the dynamic rename expression is REPLACE([_CurrentField_],"_","-").

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703