Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Help with Data Transformation Please

VahidGoli
8 - Asteroid

Hi All,

I just received a new data set that I really don't know how to transform to a format that I can conduct analysis in Tableau. As you can see, there are lots of merged cells in the Excel file.

 

I need to kind of pivoting the data in a way that I will have a separate column for "Date". So, I need my data set has the following fields:

 

Labor Activity, Rig Name, Shift, Date, Hours, Meters, Active Time, Revenue, Type

 

Thank you in advance for your help.

2 REPLIES 2
AngelosPachis
16 - Nebula

Hi @VahidGoli ,

 

I've tried bringing the data in a format that contain the columns that you asked for. Can you take a look and see if that's what you are after?

 

AngelosPachis_0-1615137196982.png

 

Please feel free to ask any questions if something is unclear about the workflow.

 

Cheers,

 

Angelos

 

VahidGoli
8 - Asteroid

It is very much appreciated.

Labels
Top Solution Authors