Good Morning,
Been trying to find a solution to a formula problem but unable to find it and hopefully some can help. Found this forumla online that works great for what i want it to do but for some reason puts a date (1/1/1900) in when the cell its referencing is blank with no date in it. Here is the formula:
=TOROW(FILTER($B$2:$G$496,$A$2:$A$496=A2))
What i am trying to do is take data to consolidate onto on row as is below based on data that is equal. Column A and b will always be constant but c,d,e, will change.:
and convert to
but as you can see it puts a date in when there is no date. Any help in fine tuning the formula to make sure if a date is blank and show blank would be helpful. Also if there is a way for column b to only show up once rather than everytime that would be great as well.
thank you.
Been trying to find a solution to a formula problem but unable to find it and hopefully some can help. Found this forumla online that works great for what i want it to do but for some reason puts a date (1/1/1900) in when the cell its referencing is blank with no date in it. Here is the formula:
=TOROW(FILTER($B$2:$G$496,$A$2:$A$496=A2))
What i am trying to do is take data to consolidate onto on row as is below based on data that is equal. Column A and b will always be constant but c,d,e, will change.:
and convert to
but as you can see it puts a date in when there is no date. Any help in fine tuning the formula to make sure if a date is blank and show blank would be helpful. Also if there is a way for column b to only show up once rather than everytime that would be great as well.
thank you.