Finding the last date of the orders

Feras95p

Dear all,

As shown in the picture below  I have one column which is column A contain the phone numbers of the customers and the columns from B to G are the days.

What I'm looking for is to have a workflow that give me as an output two columns:
First column is the Mobile numbers of the customers same as column A and the Second column is the Last date of Order which is the last cell  of the row which is filled by anything. 

Note that I have attached the picture of the required ouput.  

Sample.xlsx

atcodedog05

Hi @Feras95p 

Here is how you can do it.

Workflow:

1. Using transpose tool to convert columns to rows

2. Using formula tool to convert dates into alteryx supported dates.

3. Using filter tool to filter blanks.

4. Using summarize tool for getting max date for each mobile number.

5. Using formula tool to get the desired date format.

Hope this helps : )

Last date of the order.yxmd