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

General Discussions

Discuss any topics that are not product-specific here.
SOLVED

How would I change my data formatting on my excel sheet

Jackf99
7 - Meteor

How would I change the format of my data set from this 

IDForm17Form18Form19
1Walmart181
2Cosco26

To this,

CodeName
Comp[1].Form17Walmart
Comp[1].Form1818
Comp[1].Form191
Comp[2].Form17Cosco
Comp[2].Form182
Comp[2].Form196

Where the number in between brackets is the id

2 REPLIES 2
binuacs
21 - Polaris

@Jackf99 transpose the data

image.png

Jackf99
7 - Meteor

Lol i realized right after post but didnt know how to delete whoops

 

Labels