Data Cleaning

I am stuck at wrangling this dataset, as I have used Text to column and Regex but am stuck at transforming the header into separate columns.

I am asking the community please help me

Above image shows the sample data, while the below image is the desired result, Thank you

Data Investigation

Accepted answers

IraWatt

@SS_95 That's strange I just tried it:

I've zipped the workflow with the data below. Any stage of the gif different to what you see?

Sample.yxzp

SS_95

Thank you so much it worked!

All comments

IraWatt

Hey @SS_95,

Here is one way to do this:

Any questions or issues please ask!
Hope that Helps

Ira Watt
Technical Consultant
Watt@Bulien.com

Workflow.yxmd

SS_95

I am getting the final result as with column name 1, 2, 3, 4, 5

I have attached the dataset for your reference, thanks

flights.xlsx

IraWatt

@SS_95 That's strange I just tried it:

I've zipped the workflow with the data below. Any stage of the gif different to what you see?

Sample.yxzp

SS_95

Thank you so much it worked!

IraWatt

No worries @SS_95 😄 Glad to hear !

IraWatt

@SS_95, that doesn't sound to complicated to do. I would just watch the Interactive Lessons - Alteryx Community on the relevant topics. Interactive Lessons - Alteryx Community. If theres any part of the problem in particular you don't understand how to do in Alteryx open a question on the discussions board.

SS_95

Thank you so much

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703