Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Blending 2 Spreadsheets

G_SAND
8 - Asteroid

Hi All

I have data from 2 spreadsheets I want to blend. There is common data between the 2 but I can't think of a way of getting the data the way I want it:

Master Spreadsheet:

Part1LevelPart2Field1
a0ax
a bx
a cx
a dx
a ex

 This data is repeated in a similar fashion for multiple parts

Spreadsheet 2

 LevelPart2 Field1
0dy
 d1y1
 d2y2
 d3y3
0ez
 e1z1
 e2z2
 e3z3

Parts d and e are the same as those in the master spreadsheet. I need the header added to SS 2 (which I think is reasonably simple) but then want the data for the parts in SS 2 entered under the parts in the master:

Part1LevelPart2Field1
a0ax
a bx
a cx
a dx
a 0dy
a d1y1
a d2y2
a d3y3
a ex
a0ez
a e1z1
a e2z2
a e3z3

I need to keep both the d and e part numbers from both sheets so they will be doubled up and the 'zeros' in SS2 appear at the start of each of the data sets.

 

Hope that makes sense.

 

Thanks

 

10 REPLIES 10
mborriero
11 - Bolide

Glad to hear that it works.

 

Let me know if you need more support.

 

Would be good if you could accept the solution, if it works for you.

Labels