Creating additional columns from 2 rows of data

Hello,

I am creating an app and have been stumped very close to the end. Currently, I have all my data properly formatted in 2 columns. The 1st column is basically just the labels of what the data is representing and the second is the actual data, however; I'd like to separate out the single column of data when the labels columns switch from "Concat_VIN" to "FB#" thus creating a new column for each individual FB#. Please see picture below. Any help would be greatly appreciated!

Thank you.

Workflow

Datasets

Parse

Common Use Cases

Best Practices

Accepted answers

JoaoLeiteV

Ok,

Think I got it now haha:

1. I've used a RecordID to get the lines as a column, then I check if the column contains FB and mark it.

2. Using a multi-row formula I group the content of the FBs in the same RecordID, then with another multi-row formula, I re-write the RecordID for each group.

3. I use this info on the GroupBy in the next Cross-tab to avoid concatenating the VINs together.

The only thing is that the column names won't make much sense, as they are made using the RecordID number

Example2.yxmd

All comments

JoaoLeiteV

Hello,

I tried using a filter to get the FB out of the normal flow, a cross-tab to change it to a column, and then an Append Fields to stitch the data back together.

Is it something like this that you need? Also, the "#" in the FB is removed when using the Cross-tab Tool

Example1.yxmd

roystanding

Thank you for the quick reply. Unfortunately, that is not what I am trying to achieve. I'm trying to achieve something like the below. First picture is the current outflow of data. Theoretically I'd like to set it up so that when the label in the "Name" column switches from "Concat_VIN" to "FB #" the next group of data associated with the next FB# would be taken up to line 1 along with its corresponding data and become its own column and so on. Second Picture is what I'd like the data to look like if possible.

I appreciate your help!

JoaoLeiteV

Ok,

Think I got it now haha:

1. I've used a RecordID to get the lines as a column, then I check if the column contains FB and mark it.

2. Using a multi-row formula I group the content of the FBs in the same RecordID, then with another multi-row formula, I re-write the RecordID for each group.

3. I use this info on the GroupBy in the next Cross-tab to avoid concatenating the VINs together.

The only thing is that the column names won't make much sense, as they are made using the RecordID number

Example2.yxmd

roystanding

Perfect! You're a genius. Thank you very much for your help!

Best

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703