repeat specific cell after the detail data

Mic

Hi everyone,

Is it possible to arrange the designation under the “Spezifikation” next to the “Messeinheit”?

(I thought it works with the Generate Rows Tool and Record ID Tool, but unfortunately I can't get it)

I would be very grateful for suggestions for solutions.

Input data:

Output should look like this:

Workflow

Accepted answers

ShankerV

Hi @Mic

Step 1: Input

Step 2: Filter

Step 3:

if [Field4]="Messeinheit" and Isnull([Row-3:Field4])
then [Row-2:Field1]
elseif [Field4]="mm" and [Row-1:Field4]="Messeinheit"
then [Row-2:Field1]
elseif [Field4]="mm"
then [Row-1:New Field]
else ""
endif

Expected output:

Feel free to mark the solution of the post which helped to resolve the issue, so similar issues faced by other community members in future can be helpful to refer the solution.

Many thanks

Shanker V

All comments

binu_acs

@Mic Can you upload the input file?

JamesCharnley

@Mic as Binuacs said it's a bit easier if you can upload some kind of input, even a mocked up one to save someone from having to retype it out in order to provide a practical solution. In the absence I'll try to explain an option of what you could do though.

Since you're essentially looking to create a new column based on something in column one, the first thing you'd want to do is tag these different 'Spezification' into groups with something like a tile or multi-row formula tool. Then you'll want to isolate those Mengeneinheit rows with a filter, and at that point you'd be able to join them back on with a join tool based on the tag you just made. You'd then need a bit more to reformat it but that's the general idea.

Mic

I hope the excel file will help you. I haven't created a workflow yet.

Input.xlsx

JamesCharnley

@Mic Something like this is doing what I tried to explain:

angebotsblatt.yxzp

ShankerV

Hi @Mic

Please find the expected solution in 2 tools.

Many thanks

Shanker V

ShankerV

Hi @Mic

Step 1: Input

Step 2: Filter

Step 3:

Expected output:

Feel free to mark the solution of the post which helped to resolve the issue, so similar issues faced by other community members in future can be helpful to refer the solution.

Many thanks

Shanker V

Mic

Thanks @ShankerV, this works great!

ShankerV

Hi @Mic

Glad to know it worked for you!!! Thanks!!!

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

Aguisande 317