Entering date as column headers

[BhatiaSakshi]

Hello Team,

I have listed all my requirements, input data as well as expected output in attached excel. Please help.

[DavidP]

Hi @BhatiaSakshi 

Here is Version 3 based on the new requirement

[TheBIguy]

Hello Jonathan/All,

I want to achieve something like this. Can you help.

This is created in excel.

12/1/2020

12/2/2020

12/3/2020

12/4/2020

12/5/2020

12/6/2020

12/7/2020

12/8/2020

12/9/2020

12/10/2020

12/11/2020

12/12/2020

12/13/2020

12/14/2020

12/15/2020

12/16/2020

12/17/2020

12/18/2020

12/19/2020

12/20/2020

12/21/2020

12/22/2020

12/23/2020

12/24/2020

12/25/2020

12/26/2020

12/27/2020

12/28/2020

12/29/2020

12/30/2020

12/31/2020

Portfolio/Fund

Description

Fund Class Name

Net Assets

Net Assets

Net Assets

Net Assets

Net Assets

Net Assets

Net Assets

Net Assets

Net Assets

Net Assets

Net Assets

Net Assets

Net Assets

Net Assets

Net Assets

Net Assets

Net Assets

Net Assets

Net Assets

Net Assets

Net Assets

Net Assets

Net Assets

Net Assets

Net Assets

Net Assets

Net Assets

Net Assets

Net Assets

Net Assets

Net Assets

The date for above are coming from one of the date column so we can get date from there. The main issue is this formatting in Alteryx as excel output.

Please help!