Shift Cell Content

hrifken

Hello,

I'm trying to create a helper sheet that takes status updates for a specific project (abc123) and organizes it uniformly into a single set of columns. Currently I have to manually cut and paste all entries from the Project 2 columns and Project 3 columns into Project 1 columns. There will only be one entry per project abc123/row.

Thank you in advance for any suggestions!

KPH

Hi @hrifken

You can use IF, NOT, and ISBLANK functions.

If the Project 1 cell is not blank return the value in Project 1. If it is blank nest another IF to check if Project 2 is not blank. If that is not blank then return the value in Project 2. If it is blank then you can either nest another IF, or you can return the value in Project 3.

You can use the same logic for the other 3 columns.

Let me know if you are not familiar with how to create a nested IF function.

hrifken

Hi KPH,

Thanks for the quick response. I have it working where the cross-sheet reference is a specific cell; however, I am unable to scale to the other rows. I've tried both a simple drag and fill and updating the references to be the entire column without any luck.

Paul Newcome

How exactly is the first sheet populated, and are you able to provide a screenshot with some sample data manually entered to show the expected final outcome?