Change Date from Row to Column dynamically. Input file displayed below

Question

data file is attached with expected output format

MetricsTuesday, May 28, 2024Wednesday, May 29, 2024Thursday, May 30, 2024Work streamProducts/ServicesNameDescriptionFrequency6:00:00 AM9:00:00 AM12:00:00 PM3:00:00 PM6:00:00 PM9:00:00 PM12:00:00 AM3:00:00 AM6:00:00 AM9:00:00 AM12:00:00 PM3:00:00 PM6:00:00 PM9:00:00 PM12:00:00 AM3:00:00 AM6:00:00 AM9:00:00 AM12:00:00 PM3:00:00 PM6:00:00 PM9:00:00 PMSales statusSales statusGroceryNumber of ItemsDaily    252525   2525252525   2525252525FurnitureStylesDaily    252525   2525252525   2525252525Home AppliancesImported and ExportDaily    252525   2525252525   2525252525

excel file.xlsx

aatalai · Answer

@irfanchoudhry does this post not solve your ask https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/there-is-date-field-in-a-row-but-Date-is-required-as-a-column-i/td-p/1278276

?

terry10 · Answer

@irfanchoudhry

I suggest cleaning up your excel file first, especially unmerging cells, before inputting into Alteryx. Otherwise your results may not be repeatable.