Send to New Line

This is probably an easy one but I can't get it. I need to move columns I thru M as new lines instead of having them on the same line. Sheet 1 is what I start with and Sheet2 is what I need (highlighted lines in Tab Sheet2 contain what needs moved - anything with OT on the line).

pivot.xlsx

Developer

Input

Accepted answers

davidskaife

Hi @ewassell

Try the attached i've pulled together for you.

Send to New Line.yxmd

All comments

davidskaife

Hi @ewassell

Try the attached i've pulled together for you.

Send to New Line.yxmd

ewassell

Thanks so much. This doesn't make sense to me why it works, but it does! Why don't the column headings mess this up?

davidskaife

Hi@ewassell

In a little more detail what is happening is:

Filter on records where overtime is not 0, then remove the original columns from that stream.

Take the original records, and remove the overtime columns

Union the two streams together with the config set to 'Auto Config by Position', and the Union tool only brings in the headers from the 1st Input, which in this case is the second stream containing the original records without the overtime columns.

As the Union tool configs by position, it adds the rows from the filtered stream to the bottom and is then sorted by EmployeeID

There is probably a quicker way of doing it but this works

ewassell

THAT"S THE KEY - config set to 'Auto Config by Position', and the Union tool only brings in the headers from the 1st Input. Thank You!

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703